시간별 범위 SQL
쿼리
WITH RECURSIVE
dates (date) AS
(SELECT '2025-01-01 00:00:00' AS time
UNION ALL
SELECT DATE_ADD(date, INTERVAL 1 HOUR) AS time
FROM dates
WHERE date < DATE_SUB('2025-01-02 00:00:00', INTERVAL 1 HOUR))
SELECT * FROM dates;
결과
2025-01-01 00:00:00
2025-01-01 01:00:00
2025-01-01 02:00:00
2025-01-01 03:00:00
2025-01-01 04:00:00
2025-01-01 05:00:00
2025-01-01 06:00:00
2025-01-01 07:00:00
2025-01-01 08:00:00
2025-01-01 09:00:00
2025-01-01 10:00:00
2025-01-01 11:00:00
2025-01-01 12:00:00
2025-01-01 13:00:00
2025-01-01 14:00:00
2025-01-01 15:00:00
2025-01-01 16:00:00
2025-01-01 17:00:00
2025-01-01 18:00:00
2025-01-01 19:00:00
2025-01-01 20:00:00
2025-01-01 21:00:00
2025-01-01 22:00:00
2025-01-01 23:00:00
일자별 범위 SQL
쿼리
WITH RECURSIVE dates (date) AS
(SELECT '2025-01-01 00:00:00' AS time
UNION ALL
SELECT DATE_ADD(date, INTERVAL 1 DAY) AS time
FROM dates
WHERE date < DATE_SUB('2025-01-3
1 00:00:00', INTERVAL 1 DAY))
SELECT *
FROM dates;
결과
2025-01-01 00:00:00
2025-01-02 00:00:00
2025-01-03 00:00:00
2025-01-04 00:00:00
2025-01-05 00:00:00
2025-01-06 00:00:00
2025-01-07 00:00:00
2025-01-08 00:00:00
2025-01-09 00:00:00
2025-01-10 00:00:00
2025-01-11 00:00:00
2025-01-12 00:00:00
2025-01-13 00:00:00
2025-01-14 00:00:00
2025-01-15 00:00:00
2025-01-16 00:00:00
2025-01-17 00:00:00
2025-01-18 00:00:00
2025-01-19 00:00:00
2025-01-20 00:00:00
2025-01-21 00:00:00
2025-01-22 00:00:00
2025-01-23 00:00:00
2025-01-24 00:00:00
2025-01-25 00:00:00
2025-01-26 00:00:00
2025-01-27 00:00:00
2025-01-28 00:00:00
2025-01-29 00:00:00
2025-01-30 00:00:00