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
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. Received on Tue May 24 2005 - 08:46:32 CDT