Mysql获取天的每小时时间段

追忆未来1024

已于 2022-11-18 16:10:09 修改

阅读量470

点赞数

文章标签： mysql

于 2021-10-24 18:45:47 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_42642057/article/details/120938277

版权

Mysql获取天的每小时时间段

select pt.time as present_time FROM (
                SELECT DATE_FORMAT( DATE_SUB( DATE_FORMAT( '2021-10-19','%Y-%m-%d'),INTERVAL ( -(@i:=@i+1) ) HOUR ) ,'%Y-%m-%d %H:00') AS 'time'
                FROM (
                SELECT a  FROM
                (SELECT '1' AS a UNION SELECT '2' UNION SELECT '3' UNION SELECT '4'   ) AS a
                JOIN ( SELECT  '1' UNION SELECT '2' UNION SELECT '3' UNION SELECT '4' UNION SELECT '5' UNION SELECT '6' ) AS b
                ON 1
                ) AS b  ,(SELECT @i:=-1)  AS i
                )  pt where pt.time <= DATE_FORMAT( '2021-10-19 23:59:59','%Y-%m-%d %H:00')