Shulou(Shulou.com)06/01 Report--

The function used to convert UNIX timestamps to dates: FROM_UNIXTIME ()

Select FROM_UNIXTIME (1156219870)

Convert date to UNIX timestamp with function: UNIX_TIMESTAMP ()

Select UNIX_TIMESTAMP ('2006-11-04 12 purl 23purl 00')

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

$sql= "select * from message Where DATE_FORMAT (FROM_UNIXTIME (time),'% Ymuri% mmury% d') = DATE_FORMAT (NOW (),'% Ymuri% mmi% d') order by id desc"

Query the data of a certain day:

User_time = 'Y-m-d HRV iRV'

$sql= "select * from message Where DATE_FORMAT (FROM_UNIXTIME (time),'% Ymuri% mmury% d') = DATE_FORMAT (user_time,'% Ymuri% mmi% d') order by id desc"

Note: the time conversion of the database is still very important, now it is mostly the time to save int, the scope of query time is still very helpful.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.