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 ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Shankar MPosted Nov 27, 2012, 5:08 AM
You can get the Default NLS Parameter setting from,
SELECT *
FROM v$nls_parameters;
Thanks,
Shankar
Hemant KumarPosted Jun 29, 2012, 6:34 AM
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