MySQL Tutorial: Unix timestamp and date conversion functions

Unix timestamp converted to date function: From_unixtime ()

Select From_unixtime (1156219870);

Date converted to UNIX timestamp function: Unix_timestamp ()

Select unix_timestamp (' 2006-11-04 12:23:00′);

Example: MySQL Query the number of records of the day:

$sql = "SELECT * FROM Message Where date_format (From_unixtime (chattime), '%y-%m-%d ') = Date_format (now (), '%y-%m-%d ') ORDER BY id DESC ";

Of course, you can also choose to convert in PHP

Unix timestamp converted to date function: Date ()

Date (' y-m-d h:i:s ', 1156219870);

Date converted to UNIX timestamp function: Strtotime ()

Strtotime (' 2010-03-24 08:15:42 ');