从php添加日期到mysql以便稍后进行排序

Question

when inserting a date into a MySQL DB using PHP what is the best format so that I can sort by date later. I started using

$current_time = date("Y-m-d");

Is this the best practice?

Answer 1

If you are able to control your database fields then I would recommend using MySQL's built in Timestamp data type. You can set it to the current time by default.

CREATE TABLE IF NOT EXISTS `your_table` (
    `date` timestamp NOT NULL default CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

If not then I would reccomend just storing the default PHP Unix formatted timestamp in an integer field.

$current_time = time();