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.