Output (Transform) time formats
#
# — may be one or any combination of the following formats:
|
yyyy |
year (1900-2099) |
|
yy |
year (00-99) |
|
y |
year |
|
MM |
month (00-12) |
|
M |
month (0-12) |
|
dd |
day of month (00-31) |
|
d |
day of month (0-31) |
|
D |
day of week (1: Sunday, 2: Monday, and so on) |
|
DDD |
day of year (000-365) |
|
HH |
hour (00-23) |
|
H |
hour (0-23) |
|
hh |
hour (01-12) |
|
h |
hour (1-12) |
|
mm |
minute (00-59) |
|
m |
minute (0-59) |
|
ss |
second (00-59) |
|
s |
second (0-59) |
|
TT |
AM/PM |
|
T |
A/P |
|
tt |
am/pm |
|
t |
a/p |
|
ww |
week of year (01-53) |
|
w |
week of year (1-53) |
When using time formats, you must specify an Input Time format to define the contents of the string that is to be formatted for output.
Examples
ddMMyyyy
Description — a date in day, month, year format
Examples
Input Format: T<yyyyMMdd> the string “20051026” 
“26102005”
Input Format: T<yyyyMM> the string “102005” “102005
See also: