Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 19 Mar 2002 @ 19:51:18 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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...

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020