Date format

[ashley75]

What is the default date format in Oracle ??? Is it 'mm-dd-yyyy'???

[marist89]

The default data format is based on your NLS_DATE_FORMAT init.ora parameter. In 8.1, the default format is 'DD-MON-YY'.

SQL> select sysdate from dual;

SYSDATE
---------
18-NOV-02

SQL> alter session set nls_date_format="mm/dd/yyyy hh24:mi:ss";

Session altered.

SQL> select sysdate from dual;

SYSDATE
-------------------
11/18/2002 11:01:52

SQL> alter session set nls_date_format="yyyy.mm.dd hh24.mi.ss";

Session altered.

SQL> select sysdate from dual;

SYSDATE
-------------------
2002.11.18 11.02.52

SQL>