Archives of the TeradataForum
Message Posted: Fri, 01 Sep 2006 @ 20:41:46 GMT
| Subj: | | Re: ODBC Ansi vs Integer Dates |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Friday, September 01, 2006 16:30 -->
Glad you found the solution.
In your initial e-mail on this subject you discussed the TIMESTAMP parts of your SQL request. And you mentioned that sometimes you see an
error like "3617 ERROR Format 'YYYY-MM-DD' does not match the data type." with complex queries. But this an error related to DATE types. Also
you mentioned that problem went away if you change date time format to "AII" from "III". The first letter change affects only DATEs. So, I think
you have a problem with DATE types used in query not TIMESTAMPs.
DR 104808 -- Unable to run query with ODBC "III" setting on "date time format" For ODBC patch 3.5.0.5. Is this a fix for DATEs or
TIMESTAMPs?
| 
