Re: Can Oracle 7.x store 4-digit year dates?

Erwan Layman wrote:
>
> I am new to Oracle and I'm wondering if i can extend the year part of a
> DATE data type into 4 digits, ie, DD-MMM-YYYY. I want to avoid revamping
> my tables when year 2000 comes.
>
> Any help is appreciated. Thanks.
>
> Erwan Layman

Dear Erwan,

as far as I know, Oracle automatically handles the Year 200 problem by storing the dates internally correct.

Cheers,

Andreas Received on Fri Aug 08 1997 - 00:00:00 CDT