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