Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. DELIMITER //
  2. CREATE PROCEDURE ledigabilar(startpoint DATE, endpoint DATE)
  3. BEGIN
  4.  
  5. SELECT DISTINCT CarNumber FROM Bookings WHERE NOT ((Bookings.StartDate BETWEEN startpoint AND endpoint)
  6. OR (Bookings.EndDate BETWEEN startpoint AND endpoint)
  7. OR (Bookings.StartDate<=startpoint AND Bookings.EndDate>=endpoint));
  8.  
  9. END //
  10.  
  11.  
  12. CALL ledigabilar ('2018-01-05', '2018-01-30');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement