I have a large database of different businesses around the world that I would like to include their business hours. I'm wondering how to best store their hours in the database.
I would like to be able to nicely output their hours on my website, something like:
Wed: 10AM-12PM, 3PM-7PM
While at the same time I am looking to be able to perform database queries to search for businesses that are currently open.
Right now a single row on one table is all that is needed for each listing and ideally I would like to keep it that way.
While I don't want to display it on the website, I also realize for things like performing the currently open searches, I need to somehow account for different timezones.