Question: how to convert date into dd mm yyyy format 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.