0

I have the following question, how can I prevent a room from being scheduled if the time is already registered in the database?

Example:

Room 1 - check-in 12/20/2022 1:00 pm, check-out 12/20/2022 3:00 pm.

I need this 2 hour break not to be available for scheduling.

I have a table 'scheduling' with the following columns: id, startDate (DATE), startTime (TIME), endDate (DATE), endTime (TIME).

I can't create any logic to block this time interval, and I'm also not sure if this structure is correct in the database...

Sabatini
  • 1
  • 1
  • PSA: ISO dates of the form `YYYY-MM-DD` work better, and they match the `DATE` column format. – tadman Dec 06 '22 at 02:07

0 Answers0