Re: Dates

Subject: Re: Dates
From: "Less is more." <yvonne -at- VENUS -dot- SMARTSTAR -dot- COM>
Date: Mon, 12 Dec 1994 10:15:01 -0800

For applications the use the popular database systems, dates are covered for
the next few centuries. (I think most problems will occur with mainframe
applications.) FYI, these are the date ranges for some popular databases.

Informix January 1, 1 A.D. to December 31, 9999
Ingres January 1, 1582 to December 31, 2382
Oracle January 1, 4712 B.C. to December 31, 4712
RDB November 17, 1858 to December 31, 9999
Sybase January 1, 1753 to December 31, 9999

Internally, these databases store number of days or seconds or some unit of
time before or after a reference date. This means that the date is independent
of the display format you want to use. So, most systems provide ways to
display dates as MM/DD/YY, DD/MM/YY, DD MMM YYYY, YYYY-MM-DD, or whatever
your users need.

Also, many systems use an 8-byte variable instead of a long integer to store
values when both date and time information is needed in the same variable.
This gives enough space to store a date to the hundredth of a second for
a reasonable number of millennia.

Yvonne DeGraw
yvonne -at- smartstar -dot- com

Previous by Author: Re: STC Web Home Page
Next by Author: Date trivia
Previous by Thread: Dates
Next by Thread: Re: Dates

What this post helpful? Share it with friends and colleagues:

Sponsored Ads