Untitled
unknown
plain_text
2 years ago
364 B
5
Indexable
SELECT
DATE_ADD(CURRENT_DATE(), INTERVAL 1 DAY) AS Date,
TIME_FORMAT(flight_time, '%H:%i') AS Time,
flight_number AS Flight
FROM
flights_table
WHERE
departure_city = @DepartureCity
AND arrival_city = @ArrivalCity
AND flight_date BETWEEN CURRENT_DATE() + INTERVAL 1 DAY AND CURRENT_DATE() + INTERVAL 20 DAY
ORDER BY
flight_date ASC;
Editor is loading...