Tomas Kirkegaard foamrider

foamrider / gist:e291633b5147d0be35e7

Last active January 6, 2024 20:21 — forked from GC-Mark/gist:4bdef466a2cac58087a6

MYSQL: Generate Calendar Table - With Holidays

	/* GENERATE CALENDAR TABLE FOR MYSQL WITH WEEKEND AND HOLIDAYS
	* Added easter-function from http://planet.mysql.com/entry/?id=30328
	* Added Norwegian holidays, holidays are marked with a '1'
	* Create function first, to be used in procedure
	* Updated (2019-03-19): Changed Easter calculation, fixed some errors
	*/
	DELIMITER //
	CREATE FUNCTION EasterSunday(inYear YEAR) RETURNS DATE DETERMINISTIC
	BEGIN
	DECLARE a, b, c, d, e, f, g, h, i, k, l, m, n, p INT;