4-38
A-61635 December 2010
Transform time formats
#
#
— may be one or any combination of the following formats:
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”
yyyy
year (1900-2099)
yy
year (00-99)
y
year
MM
month (01-12)
M
month (1-12)
dd
day of month (01-31)
d
day of month (1-31)
D
day of week (1: Sunday, 2: Monday, etc.)
DDD
day of year (001-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)