Archives of the TeradataForum
Message Posted: Tue, 27 Nov 2001 @ 19:27:06 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|