$sql = "SELECT * FROM jz_data where type='5' order by number desc LIMIT 100";
如何修改查询时间段?如:查2021-12-04 07:05:00 到2021-12-05 06:00:00 这段时间的数据
$sql = "SELECT * FROM jz_data where type='5' order by number desc LIMIT 100";
如何修改查询时间段?如:查2021-12-04 07:05:00 到2021-12-05 06:00:00 这段时间的数据
这个要看你的时间段是用什么类型。 字符串型就直接比较, 如果是datetime型,要转换一下
类似这样
SELECT * FROM mscp
WHERE biz_occur_date
BETWEEN STR_TO_DATE('2021-12-04 07:05:00','%Y-%m-%d %H:%i:%s')
AND STR_TO_DATE('2021-12-05 06:00:00','%Y-%m-%d %H:%i:%s')
LIMIT 100;