Data Transformation Engine Functions and Expressions Reference Guide

Appendix B - Format Strings Date and Time Format Strings
Functions and Expressions Reference Guide
244
Japanese Time Format Strings
Sub-String Name Sub-String Value
Japanese Time
Meridian(1) + HMS
Meridian
"AM/PM"
HMS
"HH24" + MinuteSet(1)
"H24" + MinuteSet(1)
"HH12" + MinuteSet(1)
"H12" + MinuteSet(1)
MinuteSet
Separator(1) + "MM" + SecondSet(1)
"[" + Separator(1) + "MM" + SecondSet(1) + "]"
Separator(1) + "M" + SecondSet(1)
"[" + Separator(1) + "M" + SecondSet(1) + "]"
SecondSet
Separator(1) + "SS"
"[" + Separator(1) + "SS" + "]"
Separator(1) + "S"
"[" + Separator(1) + "S" + "]"
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.
MinuteSet Separator required if HMS is H24 or H12
SecondSet Separator required if MinuteSet is M