Re: Question on the date after '31-DEC-9999' in Oracle

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 24 May 2005 07:08:00 -0700
Message-ID: <1116943679.997092.134750@g14g2000cwa.googlegroups.com>

Jim Kennedy wrote:
> "Mike" <michaelnazareth_at_gmail.com> wrote in message
> news:1116942392.166012.106700_at_g49g2000cwa.googlegroups.com...
> > When I give the following
> > SQL> select to_char(enddate,'DD-MON-YYYY') from pc_mike where
enddate >
> >
> > '31-DEC-9999';
> >
> > TO_CHAR(END
> > -----------
> > 00-000-0000
> > 00-000-0000
> > 00-000-0000
> > 00-000-0000
> > 00-000-0000
> > 00-000-0000
> > 00-000-0000
> > 00-000-0000
> > 00-000-0000
> > 00-000-0000
> > 00-000-0000
> >
> > This was the result........any suggestions.
> >
> 1. Why worry about it. The docs say the dates end at 12:31:9999.
That
> seems pretty far into the future.
> 2. You could create your own date data type based on date. Give it a
eon
> component.
> Jim

I think he is preparing for Y10K bug :) Received on Tue May 24 2005 - 09:08:00 CDT