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