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. |