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,