Calculating Julian Easter date
Hello,
I need to calculate the day of the of the Julian Easter
The Algorithm is e.g for year 2000:
1)Subtract 2: 2000-2=1998
2)MOD(1998, 19) = 3
3)Multiply *11: 3*11=33
4)MOD(33, 30) = 3
5)SUBTRACT FROM 44: 44-3=41
6)We start counting from March, so it is the 41 of March 2000 => 23 April 2000
7)Next Sunday of 23/04/2000 is 30/04/2000 which is the Easter day for 2000
SELECT
44-MOD(MOD((2000-2), 19)*11, 30)
FROM DUAL
;
Can you please assist me implementing step 6 in 9i ?
It must handle year e.g 2010 as well where the output till step 5 is 21 and we dont need to count over to the next month.
Thank you in advance