I have a date column in a table stored as MM/DD/YYYY
format. I have to select and store the same date in another table in YYYY-MM-DD
format i.e. XSD Date Format. But I am not able to do it. I am using this query:
select to_date(date_column,'YYYY-MM-DD') from table;
But still I am not able to do it. Giving me error
See Question&Answers more detail:osORA-01843 : not a valid month