topic Re: changing oracle default date format in Operating System - HP-UX

changing oracle default date format

Danny Pogi — Tue, 26 Nov 2002 07:00:01 GMT

hi guys,

i would like to change the date format of my oracle db....the NLS_DATE_FORMAT parameter.

where can i tweak it?

thanks!

regards,
danny

Re: changing oracle default date format

Yogeeraj_1 — Tue, 26 Nov 2002 07:08:30 GMT

hi,
in your Database initialisation parameter file

Add:
E.g.
NLS_DATE_FORMAT=DD/MM/YYYY

Hope this Helps!
Regards
Yogeeraj

Re: changing oracle default date format

T G Manikandan — Tue, 26 Nov 2002 07:16:44 GMT

All the applications rely on the default setting of the NLS_DATE_FORMAT.
So changing the parameter should be a advisable one.

What is the need for changing this parameter.

It is safe to change it on the session level.

To change it at a session level

sql>alter session set NLS_DATE_FORMAT='....';

Else you can add it in the init.ora file

NLS_DATE_FORMAT='...'

Thanks