DATEPART (The @Date value used is '2011-09-25 19:47:00.8631597')
|
Unit of time |
Abbreviations |
Query |
Result |
ISO_WEEK |
isowk, isoww |
SELECT DATEPART(ISO_WEEK,@Date) |
38
|
TZoffset |
tz |
SELECT DATEPART(TZoffset,@Date) |
0
|
NANOSECOND |
ns |
SELECT DATEPART(NANOSECOND,@Date) |
863159700
|
MICROSECOND |
mcs |
SELECT DATEPART(MICROSECOND,@Date) |
863159
|
MILLISECOND |
ms |
SELECT DATEPART(MS,@Date) |
863
|
SECOND |
ss, s |
SELECT DATEPART(SS,@Date) |
0
|
MINUTE |
mi, n |
SELECT DATEPART(MINUTE,@Date) |
47
|
HOUR |
hh |
SELECT DATEPART(HH,@Date) |
19
|
WEEKDAY |
dw |
SELECT DATEPART(DW,@Date) |
1
|
WEEK |
wk, ww |
SELECT DATEPART(WEEK,@Date) |
40
|
DAY |
dd, d |
SELECT DATEPART(DAY,@Date) |
25
|
DAYOFYEAR |
dy, y |
SELECT DATEPART(DAYOFYEAR,@Date) |
268
|
MONTH |
mm, m |
SELECT DATEPART(MM,@Date) |
9
|
QUARTER |
qq, q |
SELECT DATEPART(QUARTER,@Date) |
3
|
YEAR |
yy, yyyy |
SELECT DATEPART(YYYY,@Date) |
2011 |
|
DATENAME (The @Date value used is '2011-09-25 19:47:00.8631597')
|
Unit of time |
Abbreviations |
Query |
Result |
WEEKDAY |
dw |
SELECT DATENAME(WEEKDAY,@Date) |
Sunday
|
MONTH |
mm, m |
SELECT DATENAME(MM,@Date) |
September | | |
0 comments:
Post a Comment