Query in MySQL -- 2
Budget: $10 – $30 USD
I need help to create an SQL query in MySQL or programming logic in PHP to know if a store is open or closed. Example a store works from 5:00 p.m. to 2:00 a.m. (24-hour format). That is, it opens every day at 5:00 p.m. and closes at 2:00 a.m. (it changes day). Now if I record the example hours of sale that that store is closed.
I share the table to run the SQL query.
I share the table to run the SQL query.