Date conversion question
Gary Puckering
garyp at cognos.UUCP
Mon Mar 2 10:54:31 AEST 1987
In article <9945 at teknowledge-vaxc.ARPA> mkhaw at teknowledge-vaxc.UUCP (Michael Khaw) writes:
>Is there a clever formula that will give you the day of the week (as a number
>between 1 and 7 or 0 and 6) given year, month, and date?
This question came up in September of last year. Here is the response I
submitted at that time:
There is an formula known as Zeller's Congruence which can be used to
calculate the day of the week given any date. I found this somewhere,
years ago when I was a teenager, memorized it and never forgot it. I
know it works for any year after 1700, maybe even earlier. I can't
remember where it came from (I did well to remember the algorithm!).
Since it uses only integer addition and division, and one comparison
operation, its fairly cheap to implement.
Here it is:
Let k be the day of the month
m be the month (March=1, April=2, ... December=10, January
and February are months 11 and 12 of the
previous year)
C be the century
D be the year of the century (adjusted according to m)
Z be the day of the week (0=Sunday, 6=Saturday)
Then:
Z = { (26m - 2)//10 + k + D + D//4 + C//4 - 2C } mod 7
where // represents integer division with truncation
Example: for February 28, 1986
k = 28
y = 1986
m = 2 - 2 = 0
if m<1 then m=m+12, y=y-1
C = 19
D = 85
Therefore:
Z = { (26*12)//10 + 28 + 85 + 85//4 + 19//4 - 2*19} mod 7
= { 31 + 28 + 85 + 21 + 4 - 38 } mod 7
= { 131 } mod 7
= 5 (Friday)
--
Gary Puckering 3755 Riverside Dr.
Cognos Incorporated Ottawa, Ontario decvax!utzoo!dciem!
(613) 738-1440 CANADA K1G 3N3 nrcaer!cognos!garyp
More information about the Comp.unix.wizards
mailing list