The following table lists the codes used to define the base date and time format within the Registry - Registry::EN::Primitives::TSdateTime node 'dateTimeFormat' field. Although all of the codes are provided below, it is recommended that you only use numeric formats and avoid using abbreviations or full names of the day or month.
Format Code |
Description |
Example Usage |
Example Output |
G |
Era designator |
G |
AD |
y |
Year |
yy yyyy or y |
96 1996 |
Y |
Year of "Week of Year" |
Y |
1997 |
u |
Extended year |
u |
4601 |
U |
Cyclic year name, as in Chinese lunar calendar |
U |
甲子 |
Q |
Quarter |
Q or QQ QQQ QQQQ |
02 Q2 2nd quarter |
q |
Stand alone quarter |
q_ or_ qq qqq qqqq |
02 Q2 2nd quarter |
M |
Month in year |
M or MM MMM MMMM MMMMM |
09 Sept September S |
L |
Stand alone month in year |
L or LL LLL LLLL LLLLL |
09 Sept September S |
w |
Week of year |
w or ww |
27 |
W |
Week of month |
W |
2 |
d |
Day in month |
d dd |
2 02 |
D |
Day of year |
D |
189 |
F |
Day of week in month |
F |
2 (2nd Wed in July) |
g |
Modified Julian day |
g |
2451334 |
E |
Day of week |
E, EE, or EEE EEEE EEEEE |
Tues Tuesday T |
e |
Local day of week (if Monday is 1st day, Tuesday is 2nd ) |
e _or _ee eee eeee eeeee |
2 Tues Tuesday T |
c |
Stand alone local day of week |
e _or _ee eee eeee eeeee |
2 Tues Tuesday T |
a |
AM/PM marker |
a |
pm |
h |
Hour in am/pm (1~12) |
h hh |
7 07 |
H |
Hour in day (0~23) |
H HH |
0 00 |
k |
Hour in day (1~24) |
k kk |
24 24 |
K |
Hour in AM/PM (0~11) |
K KK |
0 00 |
m |
Minute in hour |
m mm |
4 04 |
s |
Second in minute |
s ss |
5 05 |
S |
Millisecond (maximum of 3 significant digits); for S or SS, truncates to the number of letters
for SSSS or longer, fills additional places with 0 |
S SS SSS SSSS |
2 23 235 2350 |
A |
Milliseconds in day |
A |
61201235 |
z |
Server Time Zone: specific non-location |
z, zz, or zzz zzzz |
PDT Pacific Daylight Time |
Z |
Server Time Zone: RFC 822 Server Time Zone: localized GMT Server TIme Zone: ISO8601 |
Z, ZZ, or ZZZ ZZZZ ZZZZZ |
-0800 GMT-08:00 -08:00 |
v |
Server Time Zone: generic non-location |
v vvvv |
PT Pacific Time or United States (Los Angeles) |
V |
Server Time Zone: specific non-location, identical to z |
V |
PDT |
VVVV |
Server Time Zone: generic location |
VVVV |
United States (Los Angeles) |
W |
Week in month |
|
2 |
' |
Escape for text |
' |
(nothing) |
' ' |
Two single quotes produce one |
' ' |
' |
