Re: beginners question: four digit year

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 Sat Jun 02 2001 - 09:37:10 CDT