Archives of the TeradataForum
Message Posted: Tue, 19 Mar 2002 @ 19:51:18 GMT
Would like to offer everyone some investigative information that Mike did and sent to me. Thanks to Mike!
Further to my last message, the description of the DateTimeFormat is given in Teradata (r) ODBC Driver for Windows (tm) User's Guide Release 02.08.00 - page 4.26
'When using the driver with Teradata V2R2 or earlier releases, no action is required in order to use old-style DATEs, TIMEs, and TIMESTAMPs. When using the driver with Teradata V2R3, the default action is to use old-style DATEs, TIMEs, and TIMESTAMPs. If you wish to use ANSI DATEs, TIMEs, and/or TIMESTAMPs instead, update the Registry, or use the ODBC driver setup utility. In the section for your data source, add DateTimeFormat=XYZ, where XYZ has been replaced with AAA, III, or any other three letter combination of A and I. The first letter in the three letter combination is the DATE format, the second letter is the TIME format, and the third is the TIMESTAMP format. If the letter is A then the ANSI format is used. If the letter is I (integer) then the old-style format is used.'
This is now (slightly!) clearer...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|