Untitled
unknown
plain_text
2 years ago
364 B
4
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...