#Date searching
26-Jul-94 02:22:57
Sb: #41881-#Date searching
Fm: James Du Bois 72237,32
To: Brian Bartlett 72037,570
Brian,
The Julian day number is the number of days since January 1, 4712 B.C.
for instance today is the 26th of July, 1994. The Julian day number is
2449559, in other words, there have been 2,449,559 days since Jan. 1, 4712
B.C. to today. Please note, this number only takes up 3 bytes, and will
go to May 9, 41222 A.D. before it goes into the 4th byte. I have never
understood why the system programmers haven't been using Julian day
numbers to do date math, since all you have to do is convert both dates to
Julian day numbers and then do the operations on them. Anyway, since you
use the whole date to get the day number, there is no problem with
breaking on decades, centuries, and millenium. Of course, there is a
function to convert Julian day numbers to the Gregorian calendar date.
James Du Bois via AutoPilot
Member of the Bermuda Triangle Exploratory Expedition 1992 – 1951