query to find days between two dates.

[ranees ras]

DECLARE @startDate DATETIME
DECLARE @endDate DATETIME
SET @startDate = '2013-10-23'
SET @endDate = '2013-10-31'
;WITH dates AS 
(
    SELECT @startdate as Date,DATENAME(Dw,@startdate) As DayName
    UNION ALL
    SELECT DATEADD(d,1,[Date]),DATENAME(Dw,DATEADD(d,1,[Date])) as DayName
    FROM dates 
    WHERE DATE < @enddate
)
SELECT Date,DayName frOM dates

[Rabbit]

Please use code tags when posting code or formatted data.

What is your question?

[ranees ras]

ma question is.....how to find days between two dates using sql ??

[ck9663]

Here, read this

Happy Coding!!!


~~ CK

[ranees ras]

did you got it ? @ck9663

[swathee]

SELECT DATEDIFF(day,'2013-10-23','2013-10-31') AS DiffDate

[swathee]

Try This:

DECLARE @startDate DATETIME 
DECLARE @endDate DATETIME 
SET @startDate = DATEADD(day,-8,@enddate)
SET @endDate = @FromDate
;WITH dates AS  
( 
    SELECT @startdate  
    UNION ALL 
    SELECT DATEADD(d,1,[Date]) 
    FROM dates  
    WHERE DATE < @enddate 
) 
SELECT Date,DayName frOM dates