Re: Latest Date..

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 17 Feb 2005 10:49:06 -0800
Message-ID: <1108665973.787102@yasure>

Jim Kennedy wrote:

> "Arijit Chatterjee" <arijitchatterjee123_at_yahoo.co.in> wrote in message
> news:ea01504d.0502152026.13d2ba2_at_posting.google.com...
>

>>Dear Faculties,
>>I got a question that what is the latest Date in Oracle 7i and 8i.
>>I don't have the answer.Please help me out.
>>Regards
>>Arijit Chatterjee

>
> Do you mean the largest possible date? I think 12/31/4731 oe something like
> that.
> Jim

Oracle can store dates in the Julian era, ranging from January 1, 4712 BCE through December 31, 4712 CE (Common Era, or 'AD'). Unless BCE ('BC' in the format mask) is specifically used, CE date entries are the default.

Source:
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10743/datatype.htm#CNCPT413

The maximum date is 31-DEC-9999 IIRC.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Feb 17 2005 - 12:49:06 CST