Archives of the TeradataForum
Message Posted: Thu, 04 Apr 2002 @ 15:16:36 GMT
| Subj: || || Re: ODBC 'datetime' format |
| From: || || John K. Wight |
If you're on V2R4 or later, check to see if DATEFORM is set to ANSI. If this is the case the default formation will be 'yyyy-mm-dd' and
any date literals entered this way will work fine - no guessing even though an attribute in the DB may have a different default FORMAT set.
Also, Insure that your ODBC DATE FORMAT (Options) is set the way you want too - e.g. AAA or IAA, etc. As seen in previous messages this
translates to DATE, TIME, TIMESTAMP positional values.