Finds the date for Easter (Western) given a year.
\nSample usage: SELECT easter(YEAR(NOW()));<\/p>\n
DELIMITER \/\/\r\nCREATE FUNCTION easter(inYear YEAR) RETURNS DATE DETERMINISTIC\r\nBEGIN\r\n DECLARE a, b, c, d, e, k, m, n, p, q INT;\r\n\r\n DECLARE easter DATE;\r\n\r\n SET k = FLOOR(inYear \/ 100);\r\n SET a = MOD(inYear, 19);\r\n SET b = MOD(inYear, 4);\r\n SET c = MOD(inYear, 7);\r\n SET q = FLOOR(k \/ 4);\r\n SET p = FLOOR((13 + 8 * k) \/ 25);\r\n SET m = MOD((15-p+k-q), 30);\r\n SET d = MOD((19 * a + m), 30);\r\n SET n = MOD((4+k-q), 7);\r\n SET e = MOD((2*b+4*c+6*d+n), 7);\r\n\r\n SET easter = CASE\r\n WHEN d + e <= 9 THEN CONCAT_WS('-', inYear, '03', 22 + d + e)\r\n WHEN d = 29 AND e = 6 THEN CONCAT_WS('-', inYear, '04-19')\r\n WHEN d = 28 AND e = 6 AND a > 10 THEN CONCAT_WS('-', inYear, '04-18')\r\n ELSE CONCAT_WS('-', inYear, '04', LPAD(d + e - 9, 2, 0))\r\n END;\r\n\r\n RETURN easter;\r\nEND\r\n\/\/\r\nDELIMITER ;<\/pre>\n","protected":false},"excerpt":{"rendered":"Finds the date for Easter (Western) given a year. Sample usage: SELECT easter(YEAR(NOW())); DELIMITER \/\/ CREATE FUNCTION easter(inYear YEAR) RETURNS DATE DETERMINISTIC BEGIN DECLARE a, b, c, d, e, k, m, n, p, q INT; DECLARE easter DATE; SET k = FLOOR(inYear \/ 100); SET a = MOD(inYear, 19); SET b = MOD(inYear, 4); SET […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[4],"tags":[],"class_list":["post-160","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2IBF1-2A","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=160"}],"version-history":[{"count":1,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/160\/revisions"}],"predecessor-version":[{"id":161,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/160\/revisions\/161"}],"wp:attachment":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}