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
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 ?
>
>
I thought the max date was 31-dec-4712 but maybe things have moved on?
-- jeremyReceived on Tue May 24 2005 - 07:05:44 CDT