Date and Time Formats

When using columns defined as date, time or timestamp in DB2® databases, the format for both input and output is:

Column: Format
Date: ccyy-mm-dd
Time: hh:mi:ss
Timestamp: ccyy-mm-dd hh:mi:ss[.fff...]

Formats

Format: Description
cc: two-digit century
yy: two-digit year
mm: two-digit month
dd: two-digit day
hh: two-digit hour
mi: two-digit minute
ss: two-digit second
.fff...: optional fractional seconds
ffffff: six-digit fraction of a second
hh24: two-digit hour using a 24-hour day

In the Generate Type Tree from dialog, 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) as a text string. When generated as a text string, it might 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.

This 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.