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

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 24 May 2005 07:00:38 -0700
Message-ID: <YKqdnVibZJrTrg7fRVn-3g@comcast.com>

"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 Received on Tue May 24 2005 - 09:00:38 CDT