Date Format Codes
| Code | Description | Example |
| AD or BC | Epoch indicator | 'YYYY AD' = 2003 AD |
| A.D. or B.C. |
Epoch indicator with periods |
'YYYY B.C.' = 2003 B.C. |
| AM or PM |
Meridian indicator | 'HH12AM' = 08AM |
| A.M. or P.M. |
Meridian indicator with periods | 'HH12 A.M.' = 08 A.M. |
| DY |
Day of week abbreviated | Mon, Tue, Fri |
| DAY |
Day of week spelled out | Monday, Tuesday, Friday |
| D |
Day of week (1 - 7) | 1, 2, 5 |
| DD |
Day of month (1 - 31) | 1, 2, ..., 31 |
| DDD |
Day of year (1 - 366) | 1, 2, ..., 366 |
| FF |
Fractional seconds | .23412 |
| J |
Julian day (days since 4712 BC) | 2452822 |
| W |
Week of the month (1 - 5) | 1, 2, 3, 4, 5 |
| WW, IW |
Week of the year, ISO week of the year | 1, 2, ..., 53 |
| MM |
Two-digit month | 01, 02, ..., 12 |
| MON |
Month name abbreviated | Jan, Feb, ..., Dec |
| MONTH |
Month name spelled out | January, ..., December |
| Q | Quarter | 1, 2, 3, 4 |
| RM |
Roman numeral month | I, II, ..., XII |
| YYYY, YYY, YY, Y |
Four-digit year; last 3, 2, 1 digits of the yar |
2003, 003, 03, 3 |
| YEAR, Year, year |
Year spelled out | 'Year' = Two Thousand Three |
| SYYYY |
If BC, year is shown as negative | -1234 |
| HH, HH12 |
Hour of the half-day (1 - 12) | 1, 2, ..., 12 |
| HH24 |
Hour of the day (0 - 23) | 0, 1, 2, ..., 23 |
| MI |
Minutes of the hour | 0, 1, ..., 59 |
| SS |
Seconds of the minute | 0, 1, ..., 59 |
| SSSSS |
Seconds of the day (0 - 86399) | 39996 |
| TZD |
Time zone daylight savings; must correspond to TZR | EDT |
| TZH |
Time zone hour, together with TZM is time zone offset | -04 |
| TZM |
Time zone minute, together with TZH is time zone offset | -04 |
| TZR | Time zone region |
US/Eastern, -04:00 |
| ,./-;: | Punctuation | Literal display |
| 'text' | Quoted text | Literal display |