3800: DATATYE MISMATCH IN THEN/ELSE EXPRESSION

[prakhar]

Hi
When i am running following query
SEL COALESCE(A,CAST(' 12:63:39.999999 'AS TIME(6))) FROM employee
I am getting error 3800: DATATYPE MISMATCH IN THEN/ELSE EXPRESSION

COLUMN A IS TIME(6) IN DDL.

Please let me know the reason of this error and also the remedy...
Regards,

[prakhar]

Hi,
Can anybody help me out in this?

Regards,

[Jimm]

You created table employee in SQL Assistant when the "Allow Use Of ODBC Extensions" was allowed.

If you do a show table on Employee, it will show column as " A INTEGER FORMAT '99:99:99' NOT NULL)".

Go to Tools/ Options in SQL Assistant, clear the above option in the Query window and recreate the employee table. It will work fine then.

JimM