Data Transformation Engine Type Designer Reference Guide

Chapter 5 - Item Properties Date & Time Item Subclass Properties
Time Format Description Example
+/-ZZZZ Hours and minutes before or after the
Greenwich Mean Time. Optional for
validation, is not built on output
+0500
ZZZ A time zone abbreviation. See Time Zones for
a list of supported time zones.
EST
Custom User defined custom time format
Note After you define and save a custom format, the custom format string appears in
the Properties window. For example, the custom date format CCYYMMDD, and
the custom time format HH24MMSS display as:
{CCYYMMDD}{HH24MMSS}
Time Zones
The following table lists the supported time zones.
Time Zone Abbreviation
Hours before
Greenwich Mean Time
Hours ahead of
Greenwich Mean Time
Greenwich Mean
Time (Zulu)
GMT 0 0
West African
Time
WAT -1 +23
Azores Time AT -2 +22
No name;
Brasilia Time
### -3 +21
Atlantic Standard
Time
AST -4 +20
Eastern Standard
Time
EST -5 +19
Central Standard
Time
CST -6 +18
Mountain Pacific
Time
MST -7 +17
Pacific Standard
Time
PST -8 +16