Question: how to convert dd-mon-yy to yyyy-mm-dd in oracle?
Answer: Your data must be clean - everything must conform to the original format or you'll encounter errors on the TO_DATE conversion. Go to Tools —> Preferences —> Database —-> NLS —> Date Format and change date to DD/MM/YYYY .