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