Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple date formats in a column

2619527Feb 25 2014 — edited Feb 25 2014

I have a column with multiple date formats.  I have loaded the data into the column as varchar2(2000) but now need to update the values using the TO_DATE function.  Is there a way I can complete this process of converting multiple date formats without actually writing update statements for each date type?  help is highly appreciated...

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2014
Added on Feb 25 2014
6 comments
3,139 views