forum

Home / DeveloperSection / Forums / How to list all dates between two dates

How to list all dates between two dates

Kate Smith185608-Jul-2013

Hi Expert!

I would like list dates between two date in a SQL Server stored procedure.

For example:

Date1: 2015-05-28

Date2: 2015-05-31

Results :

2015-05-29

2015-05-30

How to calculate all dates between two given dates?

Thanks in advance.

Updated on 08-Jul-2013

Can you answer this question?

Answer

08-Jul-2013

Hi Kate!

Create a stored procedure that does something like the following:

declare @startDate date;

declare @endDate date;

select @startDate = '20150528';

select @endDate = '20150531';

with dateRange as

(

select dt = dateadd(dd, 1, @startDate)

where dateadd(dd, 1, @startDate) < @endDate

union all

select dateadd(dd, 1, dt)

from dateRange

where dateadd(dd, 1, dt) < @endDate

)

select *

from dateRange

I hope it helpful for you.