SELECT
DATE_FORMAT(ADDDATE(‘2019-01-01 00:00’,INTERVAL @h HOUR),
‘%Y-%m-%d %H:00:00’) AS already_time,
@h :=@h + 1 AS time_number
FROM ad_delivery,(SELECT @h := 0) temp
WHERE ADDDATE(‘2019-01-01 00:00’,INTERVAL @h HOUR)
<= DATE_FORMAT(‘2019-01-01 05:00’, ‘%Y-%m-%d %H:00:00’)
时间排期 时间段按小时为间隔输出
最新推荐文章于 2022-03-23 17:59:34 发布