Date and time formats
Precision can be specified on output. For example, a precision of 4 would change a date of format from ccyy-mm-dd to ccyy.
When using columns defined as dates and times in ODBC databases, the format for both input and output are:
date:
ccyy-mm-dd
time:
hh:mm:ss
timestamp:
ccyy-mm-dd hh:mm:ss[.fff...]
If the group format is fixed, the field is padded to 26 with trailing spaces.
where
|
= | a two-digit century |
|
= | a two-digit year |
|
= | a two-digit month |
|
= | a two-digit day |
|
= | a two-digit hour |
|
= | a two-digit minute |
|
= | a two-digit second |
|
= | optional fractional seconds |
An example is 2001-08-27 00:00:00 which specifies August 27, 2001.
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 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.
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.