SELECT
@num := @num + 1,
date_format( adddate(
'2018-09-25' , INTERVAL @num-1
DAY ), '%Y-%m-%d'
) AS date
FROM
temp,
(
SELECT @num := 0 ) t
WHERE
date_format( '2018-10-01' ,
'%Y-%m-%d'
)>=adddate( '2018-09-25' ,
INTERVAL @num DAY )
ORDER BY
date
查询七天内时间数据
最新推荐文章于 2024-07-18 21:24:26 发布