Data Transformation Engine Functions and Expressions Reference Guide

Appendix B - Format Strings Date and Time Format Strings
Functions and Expressions Reference Guide
246
Sub-String Name Sub-String Value
Separator Separator is optional. If specified, it can be up to 120 bytes,
composed of non-alphabetic characters. Symbol table values,
such as <CR>, can be used to indicate non-printable
characters.
When DateUnit has a variable length (M, MONTH, D, DAY), a
Separator must follow that DateUnit if data follows.
Western Time Format Strings
Sub-String Name Sub-String Value
Western Time
Hours + MinutesSet(1) + Meridian(1) + Zone(1)
Hours
HH24
H24
HH12
H12
MinutesSet
Separator(1) + "MM" + SecondSet(1)
"[" + Separator(1) + "MM" + SecondSet(1) + "]"
Separator(1) + "M" + SecondSet(1)
"[" + Separator(1) + "M" + SecondSet(1) + "]"
SecondSet
Separator(1) + "SS" + FractionSet(1)
"[" + Separator(1) + "SS" + FractionSet(1) + "]"
Separator(1) + "S" + FractionSet(1)
"[" + Separator(1) + "S" + FractionSet(1) + "]"
FractionSet
Separator(1) + MinPlaces + "-" + MaxPlaces
"[" + Separator(1) + MinPlaces + "-" + MaxPlaces +
"]"
MinPlaces
An integer from 0 to 9
MaxPlaces
An integer from 0 to 9 (must be less than
MinPlaces)
Meridian
"AM/PM"