Archives of the TeradataForum

Message Posted: Tue, 27 Nov 2001 @ 19:27:06 GMT

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

It also seems to work with Queryman version 5.2.0 and driver 2.08.01.00

Have you checked the actual format of the table? I ran into trouble with Queryman 5.2.0 and creating ANSI formatted tables when I did not set the Date/Time format to be AAA (all ANSI). It was defined with III (??) and this created Integer rather than Time fields within the table. This caused a problem when setting these fields to ANSI compatible time constants.

I checked and when created with III it created the timestamp as character rather than timestamp type. I could not even insert the values indicated in your statement into the table. I modified the driver entry again to be AAA and then it created the table correctly and allowed the insert to work.

Just something to check.

Dara Tressler
Speedway SuperAmerica LLC

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