How to keep time?

Question

MySQL

Topic: measuring kitchens at home
The client fills in a window on the site with the choice of the date and time of the measurement.
After sending the application, the manager confirms the measurement by phone (updates the status of the application).
After confirmation of the application, the date and time will be busy, i.e. the second time you cannot select this time (on the selected date).
What is the best way to organize all this? datetime? timestamp?
Separate columns in date and time tables? Or one of type Datetime? or in general Timestamp?

Answer 1

DATETIME

Answer 2

IMHO you're doing bullshit.
what the client chooses is the desired time.
Let's say you cut the day into half-hour intervals.
10:30 is busy. 11:00 free. the measurer can be in time for the next one if the apartments are nearby.
but in reality, he rather needs an hour on the road.
at the time of ordering, you will not automatically destroy it.
and if 2 or more measurers. they won't be able to take the order at 10:30