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

Jim,
is what you are saying different from what I suggested ?

Thanks,
Flavio

"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message news:GWcM9.393536$WL3.117234_at_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 Thu Dec 19 2002 - 07:04:10 CST