Date Part functions
The date part functions are listed next (we only specify the MS-SQL Server version of the interpretation of the functions):
|
Option name in the popup list |
Inserted string (where Fld is the selected field) |
|
Year |
DATEPART(yy, Fld) |
|
Quarter |
DATEPART(qq, Fld) |
|
Month |
DATEPART(mm, Fld) |
|
Day of Year |
DATEPART(dy, Fld) |
|
Day |
DATEPART(dd, Fld) |
|
Week |
DATEPART(ww, Fld) |
|
Weekday |
DATEPART(dw, Fld) |
|
Hour |
DATEPART(hh, Fld) |
|
Minute |
DATEPART(mi, Fld) |
|
Second |
DATEPART(ss, Fld) |
|
Millisecond |
DATEPART(ms, Fld) |