Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question on the date after '31-DEC-9999' in Oracle

Re: Question on the date after '31-DEC-9999' in Oracle

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Tue, 24 May 2005 14:16:28 +0200
Message-ID: <d6v5ut$4vo$1@news.BelWue.DE>


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 ?
>>
>>

>
>
> I thought the max date was 31-dec-4712 but maybe things have moved on?
>
>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US