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!

Convert String to DATE

Veerendra PatilMay 5 2021

Hi,
I am using Oracle 19, hosted on AWS.
I have a data-upload functionality where users upload XLSX/CSV files.
In XLSX there are some dates to be uploaded.
The users can enter date in any format in them like
01012020/01-Jan-2020/01-January-2020/2020-Jan-01....
How do I convert these to correct DATE to save the values correctly into the table column?
Please suggest.
Thanks

Comments
Post Details
Added on May 5 2021
3 comments
2,025 views