Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculating Julian Easter date

drbiloukosNov 17 2010 — edited Nov 17 2010
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
This post has been answered by pollywog on Nov 17 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2010
Added on Nov 17 2010
2 comments
1,976 views