Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How change NLS_DATE_FORMAT

Re: How change NLS_DATE_FORMAT

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Mon, 8 Sep 2003 14:15:56 +0200
Message-ID: <1063023077.80369@news.thyssen.com>


"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?
> (Sorry for my english)
> Thank you!
>
>

Hi Max,

in addition to what Billy stated correctly: keep in mind that any setting on the client (in the registry) will override the setting on the server.

Greetings,
Guido Received on Mon Sep 08 2003 - 07:15:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US