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
Hey Mike can u tell us how you have inserted the date more than 9999 as
u did in case while selecting the data of date more than this year as SQL> select enddate from pc_mike where enddate > '31-DEC-9999';. Please clarify how you have inserted. Show us the SQL which inserted the data of date more that 9999 year.
Regards
Terminator
Received on Wed May 25 2005 - 22:52:00 CDT