Question: how to convert dd-mon-yy to dd-mm-yyyy 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 .