Re: Date Trivia Question

From: Alex Hudghton <alex.hudghton_at_capgemini.co.uk>
Date: Fri, 08 Jan 1999 09:34:55 +0000
Message-ID: <3695D13F.3A704F63@capgemini.co.uk>

From Oracle Metalink (just to make it more confusing!)

> Summary:
> WHAT IS THE RANGE FOR A DATE DATATYPE?
>
> +=+
>
> Problem Description
> ===================
> You are inserting values into a DATE datatype column.
> What is the valid range of values for this column?
>
> Problem Explanation
> ===================
> Starting with V7.2, valid date ranges are now between January 1, 4712 B.C.
> to December 31, 9999 A.D.
>

cathexis_at_erols.com wrote:

> Greetings ng,
> The date datatype is supposed to be valid from 1/1/4712 B.C.
> until 12/31/4712 A.D. Does antbody know why this particular range was
> chosen? Just curious.
>
> Cathexis_at_erols.com
Received on Fri Jan 08 1999 - 03:34:55 CST