Conversion Varchar to Date datatype

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.

Conversion Varchar to Date datatype

Rate Topic

Display Mode

Topic Options

Author

Message

Senthilkumar

Posted 11/3/2009 4:55:48 AM

Junior Member

Group: Forum Members
Last Login: 11/3/2009 11:55:45 PM
Posts: 12, Visits: 91

Hi All,

I have to load data from varchar column which has value like '01-AUG-09' to date column.

When i do CAST as date it is throwing below error.

Error : 2666 Invalid date supplied

Please help me in identifying the issue.

Thanks
Sen

Post #17217

Senthilkumar

Posted 11/3/2009 5:50:25 AM

Junior Member

Group: Forum Members
Last Login: 11/3/2009 11:55:45 PM
Posts: 12, Visits: 91

i got the soln

SEL CAST('21-DEC-08' AS DATE FORMAT 'DD-MMM-YY')

Post #17218

« 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 8:40am