MySQL时间有关的查询
查询当前今天的数据
SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,’%Y-%m-%d’)) =date_format(now(),’%Y-%m-%d’);
查询当前这周的数据
SELECT name,submittime FROM enterprise WHERE YEARWEEK(date...
原创
2019-07-26 20:17:26 ·
410 阅读 ·
0 评论