Print out all dates between 2 dates

Question

If I have 2 days 2013-06-03 and 2013-06-10 as examples, how do I print a list of all the dates between those 2 dates?

For example, the list in this case would be:

This seems to be answered here. http://stackoverflow.com/a/1378788/2429205 let me know if I am wrong. — Iron_Tri, Jun 18 '13 at 12:47

score 5 · Accepted Answer · answered Jun 18 '13 at 12:47

5

DECLARE @Start date = '2013-06-03'
DECLARE @End date = '2013-06-10'

;WITH Dates AS 
(
    SELECT @Start AS [Date]
    UNION ALL
    SELECT DATEADD(DAY, 1, [Date])
    FROM Dates
    WHERE [Date] < @End
)

SELECT [Date] 
FROM Dates
OPTION (MAXRECURSION 0)

answered Jun 18 '13 at 12:47

Dis Shishkov

657
7
21

I prefer this solution over the duplicate link solutions! Thanks. – oshirowanen Jun 18 '13 at 15:36

score -3 · Answer 2 · edited Jun 18 '13 at 13:05

-3

I think you are looking for this:

SELECT * FROM TABLE_NAME WHERE DATE_COLUMN_NAME BETWEEN '03-JUNE-2013' AND '10-JUNE-2013'

edited Jun 18 '13 at 13:05

Jimbo

25,790
15
86
131

answered Jun 18 '13 at 12:48

Ahmed

452
3
7

This pre-supposes that you have a table pre-populated with every date between the two points, which I suspect the OP does not have (but which is not a bad idea). – Jonathan Jun 18 '13 at 12:54

Print out all dates between 2 dates

2 Answers2