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) |