Compare dates to table with days of weeks - database structure

I am building a base of elements which will have 2 dates that indicate their range (I want the range of the week and hours). I want to use this database to refer if the other date from another spot is within this range - but only focusing on day of the week and hours. What is the best way to store this data.
As the data I want to store is;
Price from monday to friday is X
Price from sunday 14:00 - 20:00 is Y
As an examples.
I am talking only about the structure of the database with the costs.

This topic was automatically closed after 69 days. New replies are no longer allowed.