Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
364 B
2
Indexable
Never
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;