Join Stack Overflow to learn, hardware store open till 11 days knowledge, and build your career. Connect and share knowledge within a single location that is structured and easy to search. Hardeare issue with our current code is that we store open time and close time. Now that means for the first day you can put 12PM - PM but the next day it's still open for another 4 hours, before it again opens up at 12PM and technically closes at 1 Hardware Store Open Till 10 Utc minute before midnight.

Does anybody have any experience with this issue, and how did hardware store open till 11 days go about solving this and setting it up in the DB? To solve this and any stote number of complex cases you might benefit from opening times being a relation, or some form of collection.

In this method your shop would have a period shore at oen and ending at 4am, another starting at midday and ending at Add to this MaxWilliams suggestion of opening periods being a start time and a duration, and you have a very flexible system. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Correct way to store a business's open hours, when they're open til past midnight Ask Question.

Asked 4 years, 11 months ago. Active 4 years, 11 months ago. Viewed times. My app have several stores. Some stores are open from say 12PM til 04AM the following day. Improve this question. Sebastian Jennings Almnes Sebastian Jennings Almnes 1, 2 2 gold badges 1 14 silver badges 30 30 bronze badges. I would change the code so that you don't need to do some daft If there's a validation saying that closing time needs to be after opening time, for example, then take out the validation and change your logic to assume that if opening time IS after closing time, then closing time is referring to the hardware store open till 11 days day.

Ie, change your app's internal logic sotre match the reality. Alternately, you could hardeare the data so that instead of storing opening time and closing time, you store opening time and opening duration. Then the closing time can be hardware store open till 11 days simply by adding hardwaer duration to the opening time. It depends What should you do with this data?

Just display hours on web page? Something else? Add a comment. Active Oldest Votes. Improve this answer. Matt Matt Instead of storing [start, end]store [start, duration]. If you want to allow for multiple intervals, store multiple of those hradware per store. AnoE AnoE 6, 1 1 gold badge 13 13 silver badges 27 27 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. Hardware store open till 11 days Overflow Blog. If it does, call the developers. Podcast Getting Dev and Ops to actually work together. Featured on Meta. State of the Stack Q1 Blog Post. Stack Overflow hardwarre Teams is now free for up to 50 users, forever. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled.