Re: Date Trivia Question

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Fri, 8 Jan 1999 09:14:22 -0500
Message-ID: <7753pk$l70$1@client3.news.psi.net>

Hi,

How many seconds are there in the range of dates? I suspect that the answer is
2 to the 32nd. This shouldn't be an issue since the current versions of Oracle store
dates as seven bytes (one for century, one for year, one for month, one for day, one
for hour, one for minute and one for seconds), but I suspect some earlier version of
Oracle stored dates as a 32 bit field.

Unlike some of the minicomputer makers Oracle showed great restraint in not
making their base date the year of their founding.

regards

Jerry

cathexis_at_erols.com wrote in message <36954d7d.109434177_at_news.erols.com>...
> 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 - 08:14:22 CST