mysql和clickhouse中获取近30天所有的日期

敢敢变成了憨憨

已于 2024-06-20 14:58:41 修改

阅读量428

点赞数 1

文章标签： mysql 数据库

于 2024-06-19 12:23:32 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_67601403/article/details/139799398

版权

WITH RECURSIVE date_series AS (
    SELECT '2024-01-07 00:05:01' AS date
    UNION ALL
    SELECT ADDDATE(date, INTERVAL 1 DAY)
    FROM date_series
    WHERE date < '2024-06-07 00:05:01'
)
SELECT DATE_FORMAT(date, '%Y-%m-%d') AS formatted_date
FROM date_series
ORDER BY date

clickhouse中

select toDate(num) as dt from (
    select arrayJoin(
        range(
            toUInt32(toDate('2024-03-15')),
            toUInt32(addDays(toDate('2024-04-14'), 1))
            )
        ) as num
    from numbers(1)
) t