I want to store the hours of restaurants in a database (sounds simple, right?). I don't want a text field where hours are entered as a lump of data, but was thinking of making a column for each day of the week and filling in the hours this way. I was planning on doing something like this...
Then I realized, what if the restaurant is open from say 4PM on Friday and doesn't close until 2am Saturday? This method won't work so well.
Any idea how I can store the open/close times taking the above problem into account?
It is not an option to just have a varchar or text column labeled hours. I'd much rather list each day separately for search purposes.