select to_date(date_column,'YYYY-MM-DD') from table;
但我仍然无法做到.给我错误
ORA-01843 : not a valid month
select to_char(date_column,'YYYY-MM-DD') from table;