oracle - How to change the date format from MM/DD/YYYY to YYYY-MM-DD in PL/SQL?

Question

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

ORA-01843 : not a valid month

Answer 1

use

select to_char(date_column,'YYYY-MM-DD') from table;