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