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

HiWhen i am running following querySEL COALESCE(A,CAST(' 12:63:39.999999 'AS TIME(6))) FROM employeeI am getting error 3800: DATATYPE MISMATCH IN THEN/ELSE EXPRESSIONCOLUMN A IS TIME(6) IN DDL.Please let me know the reason of this error and also the remedy...Regards,

prakhar 101 posts Joined 05/08
29 Oct 2009

Hi,Can anybody help me out in this?Regards,

Jimm 298 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.