mysql 时间格式存储类型为时间戳
查询当天的数据条数
SELECT FROM_UNIXTIME(a.create_date/1000, '%Y%m%d' ) as creatDate FROM agency_order a;
SELECT count(*) FROM agency_order WHERE FROM_UNIXTIME(create_date/1000, '%Y%m%d' ) = CURDATE();
SELECT * FROM agency_order WHERE FROM_UNIXTIME(create_date/1000, '%Y%m%d' ) = CURDATE();
查询当天的数据条数
SELECT FROM_UNIXTIME(a.create_date/1000, '%Y%m%d' ) as creatDate FROM agency_order a;
SELECT count(*) FROM agency_order WHERE FROM_UNIXTIME(create_date/1000, '%Y%m%d' ) = CURDATE();
SELECT * FROM agency_order WHERE FROM_UNIXTIME(create_date/1000, '%Y%m%d' ) = CURDATE();