Date Name functions
The date name 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 |
DATENAME(yy, Fld) |
Quarter |
DATENAME(qq, Fld) |
Month |
DATENAME(mm, Fld) |
Day of Year |
DATENAME(dy, Fld) |
Day |
DATENAME(dd, Fld) |
Week |
DATENAME(ww, Fld) |
Weekday |
DATENAME(dw, Fld) |
Hour |
DATENAME(hh, Fld) |
Minute |
DATENAME(mi, Fld) |
Second |
DATENAME(ss, Fld) |
Millisecond |
DATENAME(ms, Fld) |