All Forums Database
prakhar 99 posts Joined 05/08
26 Oct 2009
3800: DATATYE MISMATCH IN THEN/ELSE EXPRESSION


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 99 posts Joined 05/08
29 Oct 2009

Hi,
Can anybody help me out in this?

Regards,

Jimm 165 posts Joined 09/07
29 Oct 2009

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

You must sign in to leave a comment.