Archives of the TeradataForum

Message Posted: Thu, 27 Mar 2003 @ 08:45:44 GMT

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

When we experienced problems with this we discovered the following:

Problems have been experienced within QueryMan where columns defined as TIME(0) have actually been created as INTEGER FORMAT '99:99:99'.

The problem was raised with NCR, who originally advised unchecking the 'Allow use of ODBC SQL Extensions in queries' checkbox within QueryMan's Tools Options Query tab. They have now advised that ODBC can be reconfigured to handle date, time and timestamp values as either Integers or ANSI values.

To amend this value open QueryMan and select the menu item Tools, Define Data Source. Select the data source that you wish to amend. Click on the Configure button and then the Options button. Within this window, Teradata ODBC Driver Options, use the 'DateTime Format: (V2R3 and above)' pull down menu to select the mode required.

DateTime Format **  QueryMan successfully creates and returns columns as specified. ##
AAA     Y
AAI     Y
AIA     N - TIME(0) becomes INTEGER FORMAT '99:99:00'
AII     N - TIME(0) becomes INTEGER FORMAT '99:99:00'
IAA     Y
IAI     Y
IIA     N - TIME(0) becomes INTEGER FORMAT '99:99:00'
III     N - TIME(0) becomes INTEGER FORMAT '99:99:00'

** The left hand value specifies the DATE format; the centre value specifies the TIME value; and the right hand value specifies the TIMESTAMP value.

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