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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 24 May 2005 14:23:49 -0400
Message-ID: <JPOdneMMMICk7A7fRVn-jw@comcast.com>

"Mike" <michaelnazareth_at_gmail.com> wrote in message news:1116956830.081613.296350_at_g49g2000cwa.googlegroups.com...
> select enddate
> from pc_mike
> where trunc(enddate) > trunc(to_date('31-DEC-9999','DD-MON-YYYY'));
> ENDDATE
> ---------
> 01-JAN-00
> 01-JAN-00
> 01-JAN-00
> 01-JAN-00
> 01-JAN-00
> 01-JAN-00
> 01-JAN-00
> 01-JAN-00
> 01-JAN-00
> 01-JAN-00
> 01-JAN-00
>

what you're trying to do is the equivalent of trying to put 39 digits of precision in a NUMBER column, or 4001 bytes in a VARCHAR2, or a 4-character extension on a PC-DOS filename.

++ mcs Received on Tue May 24 2005 - 13:23:49 CDT