Date Codes
Date Part |
Date Code |
Display |
Day |
d |
1-31 |
dd |
01-31 |
|
ddd |
Sun-Sat |
|
dddd |
Sunday-Saturday |
|
Month |
m |
1-12 |
mm |
01-12 |
|
mmm |
Jan-Dec |
|
mmmm |
January-December |
|
mmmmm |
J-D (1st letter of month) |
|
Year |
yy |
00-99 |
yyyy |
1900-9999 |
|
Locale |
[$-800] or * (placed before date) |
Use localized day and month names |
Time Part |
Time Code |
Display |
Hour |
h |
Hours as 0-23 |
hh |
Hours as 00-23 |
|
Minute |
m |
Minutes as 0-59 |
mm |
Minutes as 00-59 |
|
Second |
s |
Seconds as 0-59 |
ss |
Seconds as 00-59 |
|
ss.00 |
Fractions of a second |
|
AM/PM |
AM/PM |
12-hour clock (e.g,, 2 PM) |
A/P |
12-hour clock (e.g,, 2 P) |
|
{none} |
If AM/PM omitted, will display 24-hour clock |
|
Span |
[h]:mm |
Elapsed time in hours |
[mm]:ss |
Elapsed time in minutes |
|
[ss] |
Elapsed time in seconds |