ERROR : 3789 - Multiple 'FORMAT' options with TIME data type

Tools & Utilities

ERROR : 3789 - Multiple 'FORMAT' options with TIME data type

Hi,

CREATE TABLE Temp ( col1 TIME(0) );

INSERT INTO Temp VALUES(CAST('050505' AS TIME(0) FORMAT 'HHMISS'));

I see the following error message when I execute the above INSERT statement in Mulitload,Teradata SQL Assistant and Teradata Administrator.But works fine when I execute it in Bteq.

ERROR : 3789 - Multiple 'FORMAT' options

Has anyone encountered this type of problem before.

With Regards,
Anand
1 REPLY
Junior Contributor

Re: ERROR : 3789 - Multiple 'FORMAT' options with TIME data type

Hi Anand,
do a "SHOW TABLE Temp" and check if col1 is really a TIME.
If you created it using ODBC and the ODBC Option "DateTime Format" is set to "I" for the time portion and/or "Allowing Use of ODBC SQL Extensions in Queries" in QueryMan -> Options is set, then the ODBC driver probably replaced the TIME with an INTEGER.

BTEQ is using CLI instead of ODBC...

Dieter