使用SQL生成日期范围 [英] Generate a range of dates using SQL

问题描述

我有一个SQL查询，该查询带有一个日期参数(如果我要将其放入函数中)，则需要在去年的每一天运行它.

I have a SQL query that takes a date parameter (if I were to throw it into a function) and I need to run it on every day of the last year.

如何生成最近365天的列表，以便我可以使用直接SQL做到这一点?

How to generate a list of the last 365 days, so I can use straight-up SQL to do this?

显然，生成列表0..364也是可行的，因为我总是可以的:

Obviously generating a list 0..364 would work, too, since I could always:

SELECT SYSDATE - val FROM (...);

推荐答案

无需使用超大表或ALL_OBJECTS表:

There's no need to use extra large tables or ALL_OBJECTS table:

SELECT TRUNC (SYSDATE - ROWNUM) dt
  FROM DUAL CONNECT BY ROWNUM < 366

可以解决问题.

这篇关于使用SQL生成日期范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！