 |
 |
Archives of the TeradataForum
Message Posted: Tue, 19 Mar 2002 @ 19:51:18 GMT
| Subj: | | Re: Timestamp data type |
| |
| From: | | John K. Wight |
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...
| |
