Year |
yy |
1-9999 |
Quarter |
qq |
1-4 |
Month |
mm |
1-12 |
Week |
wk |
1-54. Weeks begin on Sunday. |
Day |
dd |
1-31 |
Dayofyear |
dy |
1-366 |
Weekday |
dw |
1-7 (Sunday = 1, ..., Saturday = 7) |
Hour |
hh |
0-23 |
Minute |
mi |
0-59 |
Second |
ss |
0-59 |
Millisecond |
ms |
0-999 |
Calyearofweek |
cyr |
Integer. The year in which the week begins. The week containing the first few days of the year may have started in the previous
year, depending on the weekday on which the year started. Years starting on Monday through Thursday have no days that are
part of the previous year, but years starting on Friday through Sunday start their first week on the first Monday of the year.
|
Calweekofyear |
cwk |
1-54. The week number within the year that contains the specified date. |
Caldayofweek |
cdw |
1-7. (Monday = 1, ..., Sunday = 7) |