Shulou(Shulou.com)05/31 Report--

mysql how to UNIX timestamp and date conversion, many novices are not very clear about this, in order to help you solve this problem, the following small series will be explained in detail for everyone, there are people who need this can learn, I hope you can harvest.

UNIX timestamp to date conversion with the function FROM_UNIXTIME()

select FROM_UNIXTIME(1156219870);

UNIX_TIMESTAMP() for converting dates to UNIX timestamps

Select UNIX_TIMESTAMP(’2006-11-04 12:23:00′);

Example: Query the number of records on 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";

Did reading the above help you? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.

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.