Question: how to convert any date format to dd/mm/yyyy in oracle?
Answer: Oracle date format ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD'; To verify the change, you can execute the statement that displays the current system date again: SELECT sysdate FROM dual; You should see the following value that matches with the date format to which you have changed.