The time conversion in SQL Drip 42-mysql

Text: Time conversion in SQL Drip 42-mysql

Unix timestamp converted to date function: From_unixtime ()

Select From_unixtime (1156219870);

Date conversion to UNIX timestamp function: Unix_timestamp ()

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

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

$sql = "SELECT *" from the 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 conversion to UNIX timestamp function: Strtotime ()

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

Time conversion in SQL Drip 42-mysql