Data Transformation Engine Functions and Expressions Reference Guide

Appendix B - Format Strings Date and Time Format Strings
Functions and Expressions Reference Guide
242
Binary Date and Time Format Strings
Sub-String Name Sub-String Value
Binary DateTime
[ "{" + Date + "}" ] + [ "{" + Time + "}" ]
Date
CCYYMMDD
YYMMDD
CCYYDDD
YYDDD
Time
HH24MMSS
HH24MM
Japanese Date and Time Format Strings
Sub-String
Name
Sub-String Value
Japanese
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 –
EY, M, or D for Date or H24, H12,
M, or S for Time.