![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Thu, 04 Apr 2002 @ 13:45:10 GMT
Subj: | | Re: ODBC 'datetime' format |
|
From: | | Geoffrey Rommel |
| In the above line, What EXACTLY does 'DATE format' mean? | |
It means that the default format used when returning dates will be either 'YYYY-MM-DD' (ANSI) or 'MM/DD/YY' (Integer). I believe that
this default format will also be applied to date literals in your SQL, so if it's set to 'A' you should specify date literals in 'YYYY-MM-
DD' form.
| And why did my queryman/command of create table with a column defined as TIME get converted to INTEGER, and TIMESTAMP to char,
when the DATETIME format was set to 'I' for both? | |
Not sure, but I believe this has something to do with the ODBC setup. If you are using ODBC driver 3.00, checking the option "Disable
PREPARE" may solve this problem. Anyone??
--wgr
| |