Data Transformation Engine ODBC Adapter Reference Guide

Chapter 2 - Database Columns and Types Date and Time Formats
ODBC Adapter Reference Guide
9
date:
ccyy-mm-dd
time:
hh:mm:ss
timestamp:
ccyy-mm-dd hh:mm:ss[.fff…]
Note If the group format is fixed, the field is padded to 26 with trailing spaces.
where
cc
=
a two-digit century
yy
=
a two-digit year
mm
=
a two-digit month
dd
=
a two-digit day
hh
=
a two-digit hour
mm
=
a two-digit minute
ss
=
a two-digit second
.fff…
=
optional fractional seconds
An example is 2001-08-27 00:00:00 which specifies August 27, 2001.
Note In the Generate Type Tree from dialog box, use the Represent date/time
columns as text items check box to define whether to automatically format this
information as Date & Time (which is with this check box disabled, the result of
which is shown in the Item Subclass, Presentation column above) as a text
string. When generated as a text string, it may be necessary to use either the
TEXTTODATE or TEXTTOTIME function in a map rule to convert the text string to
the date and time format required by the database. If you are generating new
type trees, it is recommended that you disable this check box.
The Represent date/time columns as text items check box is modal. After it
has been disabled, it will remain disabled for all subsequent type tree generations,
regardless of source. Therefore, you must be careful in determining this setting.