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
Jeremy wrote:
> In article <1116935568.121663.270500_at_g43g2000cwa.googlegroups.com>, Mike
> says...
>
>>Questions: >>1. Is the data in column "enddate" > 31-DEC-9999 i.e 01-JAN-10000 ? >>2. How can I display it in Oracle ? >>3. I was given to understand that 31-DEC-9999 is the last date for >>datatype "DATE". How is the above even possible ? >>4. Is this a bug I need to report ? >> >>
Not according to the documentation (sql reference 9i):
DATE Valid date range from January 1, 4712 BC to December 31, 9999 AD
HTH
Holger
Received on Tue May 24 2005 - 07:16:28 CDT