Date formats
The following table describes common date formats used by PDI transformation steps and job entries:
Symbol
Meaning
Type
Example
G
Era
Text
"GG" -> "AD"
y
Year
Number
"yy" -> "03"
"yyyy" -> "2003"
M
Month
Text or Number
"M" -> "7"
"M" -> "12"
"MM" -> "07"
"MMM" -> "Jul"
"MMMM" -> "December"
d
Day in month
Number
"d" -> "3"
"dd" -> "03"
h
Hour(1-12, AM/PM)
Number
"h" -> "3"
"hh" -> "03"
H
Hour (0-23)
Number
"H" -> "15"
"HH" -> "15"
k
Hour (1-24)
Number
"k" -> "3"
"kk" -> "03"
K
Hour (0-11, AM/PM)
Number
"K" -> "15"
"KK" -> "15"
m
Minute
Number
"m" -> "7"
"m" -> "15"
"mm" -> "15"
s
Second
Number
"s" -> "15"
"ss" -> "15"
S
Millisecond (0-999)
Number
"SSS" -> "007"
E
Day in week
Text
"EEE" -> "Tue"
"EEEE" -> "Tuesday"
D
Day in year (1-365 or 1-364)
Number
"D" -> "65"
"DDD" -> "065"
F
Day of week in month (1-5)
Number
"F" -> "1"
w
Week in year (1-53)
Number
"w" -> "7"
W
Week in month (1-5)
Number
"W" -> "3"
a
AM/PM
Text
"a" -> "AM"
"aa" -> "AM"
z
Time zone
Text
"z" -> "EST"
"zzz" -> EST"
"zzzz" -> Eastern Standard Time"
X
Time zone offset
Text
"XXX" -> "-08:00"
'
Escape for text
Delimiter
"hour'h" -> "hour 9"
''
Single quote
Literal
"ss''SSS" -> "45'876". Use two quote marks in a row to create a single quote in a string.
Last updated
Was this helpful?