sql_ssis
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment