Monday, September 23, 2013

Sql to get day of quarter and day of year



 
Declare
@dd datetime;

Declare
@cntr int;

Set
@cntr=0;

Select
@dd=DATEADD (dd ,@cntr , '2013-08-11' )

 
Select
 
DATEDIFF(d, DATEADD(qq, DATEDIFF(qq, 0, @dd), 0), @dd) + 1 AS dayOfQuarterCnt

,
DATEPART(dy, @dd) AS dayOfYearCnt


 






No comments:

Post a Comment