Question: how to convert dd-mm-yyyy to yyyy-mm-dd in oracle?
Answer: If you want to perform the conversion in one step, you might want: select to_char(to_date(date_column,'MM/DD/YYYY'), 'YYYY-MM-DD') from table; In other words, for each row, parse it in MM/DD/YYYY format, then reformat it to YYYY-MM-DD format.