Data Transformation Engine Functions and Expressions Reference Guide

Appendix B - Format Strings Date and Time Format Strings
Functions and Expressions Reference Guide
245
Western Date and Time Format Strings
Sub-String Name Sub-String Value
Western DateTime
"{" +DateTime + "}"
"{" +DateTime + "}" + Separator(1) + "{" + DateTime +
"}"
"{" +DateTime + "}" + "[" + Separator(1) + "{" + DateTime +
"}" + "]"
DateTime
Date
Time
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.
The Separator is required if the second
DateTime option is
used and the format string of the first
DateTime ends in a
variable sized specification – M, MONTH, D, or DAY for Date or
H24, H12, M, or S for Time.
Western Date Format Strings
Sub-String Name Sub-String Value
Date
DateUnit + DatePart2(1)
DatePart2
Separator(1) + DateUnit + DatePart3(1)
"[" + Separator(1) + DateUnit + DatePart3(1) + "]"
DatePart3
Separator(1) + DateUnit + DatePart4(1)
"[" + Separator(1) + DateUnit + DatePart4(1) + "]"
DatePart4
Separator(1) + DateUnit
"[" + Separator(1) + DateUnit + "]"