Oracle DEFAULT DATE FORMAT

If you're looking for Oracle SQL's default date format, this is the right page for you.

Oracle SQL's Default Date Format is 'DD-MON-YY'.

In SQL*Plus prompt, type this command:

SQL> SELECT sysdate FROM dual;

The above query will return the system date. Its format is 'DD-MON-YY' which is the default date format of Oracle.

Thanks for visiting my blog.



- Millionaire Mind Ben de Leon