The following table lists the codes used to define the base date and time format within the Registry application 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
(e.g. 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 |
Time Zone: specific non-location |
z, zz, or zzz
zzzz |
PDT
Pacific Daylight Time |
Z |
Time Zone: RFC 822
Time Zone: localized GMT
TIme Zone: ISO8601 |
Z, ZZ, or ZZZ
ZZZZ
ZZZZZ |
-0800
GMT-08:00
-08:00 |
v |
Time Zone: generic non-location |
v
vvvv |
PT
Pacific Time or United States (Los Angeles) |
V |
Time Zone: specific non-location, identical to z |
V |
PDT |
VVVV |
Time Zone: generic location |
VVVV |
United States (Los Angeles) |
W |
Week in month |
|
2 |
' |
Escape for text |
' |
(nothing) |
' ' |
Two single quotes produce one |
' ' |
' |