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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Date settings in oracle (NLS db dependent ?)

Re: Date settings in oracle (NLS db dependent ?)

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Thu, 19 Dec 2002 05:37:42 GMT
Message-ID: <GWcM9.393536$WL3.117234@rwcrnsc54>


The date is stored in a binary format and is NOT stored American or Dutch. You can choose via the NLS settings to present the date as a string to the GUI in a particular format.
Jim
"FC" <flavio_at_tin.it> wrote in message
news:c_6M9.2646$Q%4.79341_at_news1.tin.it...
> "@did" <adid_at_pandora.ns.be> wrote in message
> news:62e10vsaihh1q2m5c2mo36nag1pv6houqd_at_4ax.com...
> >
> > Hi,
> >
> > It is the following: I made a database, on my PC and I noticed that
> > the date is stored in Dutch in the database. All the settings in
> > props$ are set to 'American' but still every date is stored in Dutch.
> >
> > Is there somebody who knows how I can change the way of storing a date
> > for this specific database ?
> >
> > Thx in advance !
>
>
> What's the content of the following registry key ?
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\NLS_LANG
>
> Bye,
> Flavio
>
>
Received on Wed Dec 18 2002 - 23:37:42 CST

Original text of this message

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