使用 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;