|
Element |
Description |
|
Date Format |
|
SCC or CC |
Centry; S
prefixes BC date with - |
|
YYYY or
SYYYY |
Year; S
prefixes BC date with - |
|
YYY or YY
or Y |
Last 3,
2, or 1 digits of year |
|
Y,YYY |
Year with
comma in this position |
|
IYYY, IYY,
IY, I |
4, 3, 2,
or 1 digit year based on the ISO standard |
|
SYEAR or
YEAR |
Year
spelled out; S prefixes BC date with - |
|
BC or AD |
BC/AD
indicator |
|
B.C. or
A.D. |
BC/AC
indicator with periods |
|
Q |
Quarter
of year |
|
MM |
Month,
two-digit value |
|
MONTH |
Name of
month padded iwth blanks to length of 9 characters |
|
MON |
Name of
month, three-leter abbreviation |
|
RM |
Roman
numeral month |
|
WW or W |
Week of
year or month |
|
DDD or DD or D |
Day of
year, month or week |
|
DAY |
Name of
day padded iwth blanks to length of 9 characters |
|
DY |
Name of
day; 3 letter abbreviation |
|
J |
Julian
day; the number of days since 31 December 4713 BC |
|
Time Format |
|
AM or PM |
Meridian
indicator |
|
A.M. or
P.M. |
Meridian
indicator with periods |
|
HH or
HH12 or HH24 |
Hour of
day or hour(1-12) or hour(0-23) |
|
MI |
Minute
(0-59) |
|
SS |
Second
(0-59) |
|
SSSSS |
Seconds
past
midnight (0-86399) |
|
Date Display Suffixes |
|
TH |
Ordinal
number (i.e. DDTH for 5TH) |
|
SP |
Spelled-out number (i.e. DDSP for
FIVE) |
|
SPTH or
THSP |
Spelled-out ordinal numbers (i.e. DDSPTH for FIFTH) |
|
Other Date Formatting |
|
/ , . |
Punctuation is reproduced in the result |
|
"of the" |
Quoted
string is reproduced in the result |
