My advice: don't. You're using the wrong tool for the job. Holidays are *complicated,* messy human constructs, not something that submits well to deterministic tools like SQL. [This][1] is the right tool. [1]: https://metacpan.org/pod/distribution/Date-Manip/lib/Date/Manip/Holidays.pod