Re: beginners question: four digit year

From: dhmac <dhmac_atl_at_altavista.com>
Date: Tue, 12 Jun 2001 20:21:56 -0400
Message-ID: <9g6bkk$nmn$1@slb0.atl.mindspring.net>

And if you use "RRRR" instead of "YYYY" Oracle will automatically correct years entered with only two-digits for the 2000 rollover.

Ex. with "YYYY": '99' translates to '0099' while, with "RRRR": '99' translates to '1999'

"Jerzy Bin" <jerzy.bin_at_chello.at> wrote in message news:3B18FA0E.82161E12_at_chello.at...
> You can set up NLS_DATE_FORMAT parameter in your INIT.ORA file
> to anything you want.
> i.e. NLS_DATE_FORMAT="DD-MM-YYYY"
>
> Cheers
>
> jdentwickler_at_gmx.de wrote:
> >
> > Hello !
> >
> > I hope you can help me:
> >
> > When select date values from an oracle database I always get the
> > year with two digits displayed.
> > Of course I can decode the date with the oracle function and an
> > recompose a new date format with a four digit year,
> > but is there an easy way to confige oracle (8.1.x) to deliver the date
> > always with a four digit year ?
> >
> > Thank you
> > J.F.Sebastian
Received on Tue Jun 12 2001 - 19:21:56 CDT