Machine 1
Start : 2002/12/12 10:00 a.m.
Finish : 2002/12/13 10:00 a.m.
How to make a querry to show that Machine 1 is unavailable
if user register another time between the above slot.
I am writting a db to monitor my machine capacity. Suppose I have 3 machines A, B and C, I create a form to the user to register/book the machine before they use. Let's say I register machine A on 12.12.2002, 15:00-17:00, another user might register with machine A too on 12.12.2002, 16:00-18:00...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.