Re: beginners question: four digit year

or "alter session set nls_date_format='DD-MON-YYYY;"

"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 Mon Jun 04 2001 - 04:52:38 CDT