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: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Tue, 24 May 2005 13:05:44 +0100
Message-ID: <MPG.1cfd28efe8305951989e83@news.individual.net>


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?

-- 

jeremy
Received on Tue May 24 2005 - 07:05:44 CDT

Original text of this message

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