All Forums Database
jehan 12 posts Joined 11/08
11 Nov 2008
one column, of string data type, having different date formates, how to transforms it to one formate

I have one column, of string data type, having different date formates, how to transforms it to one formatefor example 14-6-197625/10/198421 July,19799-2-197914-6-197614-6-197621 July,197925/10/198425/10/198421 July,1979I want to conver it to "DD-MM-YYYY" format thanks

Adeel Chaudhry 773 posts Joined 04/08
11 Nov 2008

Hello,I remember such question being asked couple days back...but wasn't able to find it.Once again the same answer is: Your best option will be to implement a UDF or get the is_date or to_date UDF from Teradata downloads.Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

Adeel Chaudhry 773 posts Joined 04/08
11 Nov 2008

You can get Oracle UDFs for Teradata from:http://www.teradata.com/DownloadCenter/Topic9228-137-1.aspxHTH.Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.