List of Bank Holidays For England in SQL Format

List of Bank Holidays For England in SQL Format

Get Social!

First off let’s create a table to store the bank holiday values. You may need to adjust this slightly depending on your SQL server technology being used (this was tested on MySQL/ MariaDB Server) but this is standard SQL dialect and should work on any RDBMS that respects the current SQL standards.

The next step is to insert the bank holiday values below. This table is currently for 2012 up to 2019 for England and Wales.

For a more up to date list, please see my github page.

Please submit a PR if you have collated a list yourself, or have any updates to an existing list. The repository currently covers the UK, but I’d be more than happy to accept a PR for other countries! 

Related posts:

Leave a Reply

Visit our advertisers


Quick Poll

Which type of virtualisation do you use?
  • Add your answer

Visit our advertisers