Archives of the TeradataForum

Message Posted: Thu, 04 Apr 2002 @ 06:20:38 GMT

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

Hi

This also got me puzzled a while ago; these messages copied in below were the resolution to it. Hope it helps!

Regards

Mike Philips

---------------------------------------------------

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