3800: DATATYE MISMATCH IN THEN/ELSE EXPRESSION

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

3800: DATATYE MISMATCH IN THEN/ELSE...

Rate Topic

Display Mode

Topic Options

Author

Message

prakhar

Posted 10/27/2009 12:26:40 AM

Supreme Being

Group: Forum Members
Last Login: 10/29/2009 2:48:53 AM
Posts: 94, Visits: 321

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,

Post #17161

prakhar

Posted 10/29/2009 2:49:34 AM

Supreme Being

Group: Forum Members
Last Login: 10/29/2009 2:48:53 AM
Posts: 94, Visits: 321

Hi,
Can anybody help me out in this?

Regards,

Post #17191

jimm

Posted 10/29/2009 3:00:16 AM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111, Visits: 263

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

Post #17193

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 5:48am