Murray’s company needed an easy way to tell whether or not a given date was a banking holiday or not. Someone wrote this function for MySQL .

CREATE FUNCTION `IS_HOLIDAY`(a_date datetime) RETURNS char(5) CHARSET utf8 COLLATE utf8_bin

   DECLARE is_holiday char(5);

     select (CASE WHEN (DAYOFWEEK(a_date) = 1 OR DAYOFWEEK(a_date) = 7)

                      THEN 'Yes' ELSE 'No' END) INTO is_holiday;

   RETURN is_holiday;


  Murray apparently works for Ebenezer Scrooge, and should be grateful that he gets weekends off.

[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!