3 回答
至尊寶的傳說
TA貢獻1789條經驗 獲得超10個贊
使用 Sqlite，您可以直接在 SQL 中執行此操作，無需 python，這要歸功于遞歸 CTE：
CREATE TABLE days(day TEXT PRIMARY KEY) WITHOUT ROWID;
INSERT INTO days(day)
WITH RECURSIVE alldays(day) AS
(VALUES ('2018-01-01')
UNION ALL
SELECT date(day, '+1 day')
FROM alldays
LIMIT 366 -- Take leap years into account
)
SELECT day FROM alldays WHERE day <= '2018-12-31';
-- List days in October:
SELECT day FROM days WHERE day BETWEEN '2018-10-01' AND '2018-10-31' ORDER BY day;
添加回答
舉報
0/150
提交
取消