carlospuk

DELIMITER $$

DROP PROCEDURE IF EXISTS `ocdata`.`getNextTripsForStop`$$

CREATE PROCEDURE `ocdata`.`getNextTripsForStop` (IN stop      VARCHAR(10))
BEGIN
SET @DayOfTheWeek = LCASE(DATE_FORMAT(NOW(),'%W'));
SET @DayOfTheWeekYesterday = LCASE(DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 DAY),'%W'));
SET @StopID = stop;