Default Date Format

[irehman]

Where can I change the default date format of the database to DD/MON/YYYY

Thanks in advance.

[gsprince]

in the init.ora file you can add the following line.

nls_date_format = "DD/MON/YYYY"

[Oracledba8]

If You want to Change the date format for the current session only then use this

Alter session set nls_date_format = 'DD-MON-YYYY';

This will help you.

Thanks..