Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can Oracle 7.x store 4-digit year dates?

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

From: Michael <mbowman_at_verticalworks.com>
Date: 1997/08/15
Message-ID: <01bca997$0a67ec70$013296b4@tower>#1/1

ORACLE automatically stores the date in a format that handles dates from BC to the far distant future... If your dates are showing up as MMDDYY, try using the NLS SESSION command to alter the date format.

Michael Bowman

Andreas Wilhelm <a_wilhelm_at_overnet.de> wrote in article <33EB17DA.385A_at_overnet.de>...
> 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 15 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US