OPERATION
Supported time formats
Value Description
h Hours with no leading zero for single-digit hours; 12-hour clock
hh Hours with leading zero for single-digit hours; 12-hour clock
H Hours with no leading zero for single-digit hours; 24-hour clock
HH Hours with leading zero for single-digit hours; 24-hour clock
m Minutes with no leading zero for single-digit minutes
mm Minutes with leading zero for single-digit minutes
s Seconds with no leading zero for single-digit seconds
ss Seconds with leading zero for single-digit seconds
t One character time marker string, such as A or P
tt Multi character time marker string, such as AM or PM
For example, to get the time string "11:29:40 PM", use the following picture string:
"hh':'mm':'ss tt"
Suppo cial formats rted spe
Value Description
doy Day of year
Y Day of year (always three digits) DO
woy Week of year
WOY Week of year (always two digits)
Dow Day of week (Sunday=0, Monday=1…Saturday=6).
(
120) 27864 Issue 1 January 2008