When adding Date/Time functions to your transformation rules, use the following syntax to specify the format. All examples use the US English locale.
|
Symbol |
Description |
Presentation |
Example |
|
a |
AM/PM marker |
Text |
PM |
|
d |
Day in month |
Number |
10 |
|
D |
Day in year |
Number |
189 |
|
E |
Day in week |
Text |
Tuesday; Tue |
|
F |
Day in week in month |
Number |
2 (2nd Wed in July) |
|
G |
Era designator |
Text |
AD |
|
h |
Hour in am/pm (1-12) |
Number |
12 |
|
H |
Hour in day (0-23) |
Number |
0 |
|
k |
Hour in day (1-24) |
Number |
24 |
|
K |
Hour in am/pm (0-11) |
Number |
0 |
|
m |
Minute in hour |
Number |
30 |
|
M |
Month in year |
Month |
July; Jul; 07 |
|
s |
Second in minute |
Number |
55 |
|
S |
Millisecond |
Number |
978 |
|
w |
Week in year |
Number |
27 |
|
W |
Week in month |
Number |
2 |
|
y |
Year |
Year |
1996; 96 |
|
z |
Time zone |
General time zone |
Pacific Standard Time |
|
Z |
Time zone |
RFC 822 time zone |
0800 |
|
\' |
Escape for text |
Delimiter |
'yyyy.MM.dd G \'at\' HH:mm:SS z' |
|
\'\' |
Single quotes |
Literal |
'MMMM dd, \'\'yy' |
For more information, go to java.text.SimpleDateFormat @ http://java.sun.com/j2se/1.4.1/docs/api/java/text/SimpleDateFormat.html.