Mysql 根据时间戳查询当天的数据

select * from table Where DATE_FORMAT(FROM_UNIXTIME(create_time),’%Y-%m-%d’) = DATE_FORMAT(NOW(),’%Y-%m-%d’)

SELECT unix_timestamp(now());

来源：https://blog.csdn.net/asenseof/article/details/107918573