Mysql查询时间数据
Mysql查询时间数据1、查询当天数据
SELECT * FROM `cb_gwxx` WHERE TO_DAYS() = TO_DAYS(NOW()) and name='j'2，查询5分钟内的数据
select * from cb_gwxx where shijian >= DATE_SUB(NOW(),INTERVAL 5 MINUTE);
3，查询指定月数据SELECT * FROM `cb_gwxx` WHERE DATE_FORMAT(shijian,'%Y-%m') = '2021-06'
4，查询任一段时间数据SELECT * FROM `cb_gwxx` WHERE shijian between '2021-06-12' and'2021-06-15'
页:
[1]