mysql 查询近24小时的各个时间段的时间
SELECT DATE_FORMAT( DATE_SUB( NOW(),INTERVAL ( -(@i:=@i-1) ) HOUR ) ,'%Y-%m-%d %H') AS 'time' FROM ( SELECT a FROM (SELECT '1' AS a UNION SELECT '2' UNION SELECT '3' UNION SELECT '4' ) AS a JOIN ( ...
原创
2022-03-17 15:32:39 ·
974 阅读 ·
0 评论