Date and time formats
When using columns defined as datetime or smalldatetime in Microsoft™ SQL Server databases, the format for both input and output is:
datetime:
ccyy-mm-dd hh:mm:ss.fff
smalldatetime:
ccyy-mm-dd hh:mm:ss
where
|
= | a two-year 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 |
|
= | fractional seconds |
An example is 2001-08-27 00:00:00.000 which specifies August 27, 2001.
In the Generate Schema 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 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 schemas, 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 schema generations, regardless of source. Therefore, you must be careful in determining this setting.