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

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 24 May 2005 07:40:43 -0700
Message-ID: <1116945643.404489.289510@g47g2000cwa.googlegroups.com>

Mike wrote:
> I tried
> 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
>
> The point I am trying to make is.
> How can a number > than '31-DEC-9999' be inserted?
> Why can't I view it?

Can you post the results of

select dump(enddate)
from <as in your query>
where <as in your query>;

Regards
/Rauf Received on Tue May 24 2005 - 09:40:43 CDT