Untitled
Anonymous
plain_text
07/15/2023 1:13 PM
488 B
17
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...