Re: How change NLS_DATE_FORMAT

"Max" <massimo.panero_at_ideainformatica.org> wrote

> I've to change the default date format for Oracle sessions.
> I've understood that I have to change the NLS_DATE_FORMAT parameters.
> If I use ALTER SESSION, I change this setting only for that session.
> How can I change this setting for all sessions?

You need to set it as a database parameter. You did not mention your Oracle version number (and hardware platform) - that is something you always should add to your postings here.

With Oracle 8, you will have an initSID.ora file. With Oracle 9i, you can use OEM. Simply set the NLS_DATE_FORMAT in there.

--
Billy