Date Format in Oracle

Question

Hi Friends I want to know the default format of date in oracle and how can I change this default format of date in oracle ?

Shankar M · Answer

Hi User You can get the Default NLS Parameter setting from SELECT * FROM v$nls_parameters; Thanks Shankar

Hemant Kumar · Answer

You can change the default data format within Oracle by adjusting the nls_date_format initialization parameter. Changing the default date format can be done at the session or system level. ALTER SESSION SET NLS_DATE_FORMAT='DD/MM/YYYY'; ALTER SYSTEM SET NLS_DATE_FORMAT='DD/MM/YYYY' scope=both; Refer this link http://dba-oracle.com/t_how_to_change_the_default_data_format.htm