雅安论坛

标题: Mysql查询时间数据 [打印本页]

---

作者: 匿名    时间: 2021-6-12 21:39
标题: Mysql查询时间数据
Mysql查询时间数据

1、查询当天数据

1. SELECT * FROM `cb_gwxx` WHERE TO_DAYS() = TO_DAYS(NOW()) and name='j'

复制代码

2，查询5分钟内的数据

1. select * from cb_gwxx where shijian >= DATE_SUB(NOW(),INTERVAL 5 MINUTE);

复制代码

3，查询指定月数据

1. SELECT * FROM `cb_gwxx` WHERE DATE_FORMAT(shijian,'%Y-%m') = '2021-06'

复制代码

4，查询任一段时间数据

1. SELECT * FROM `cb_gwxx` WHERE shijian between '2021-06-12' and  '2021-06-15'

复制代码

---

欢迎光临 雅安论坛 (https://www.yaanbbs.net/)

Powered by Discuz! X3.4