Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question on the date after '31-DEC-9999' in Oracle
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?
Received on Tue May 24 2005 - 09:16:56 CDT