Untitled
unknown
plain_text
2 years ago
344 B
3
Indexable
SELECT DATEADD(DAY, 1, GETDATE()) AS Date, CONVERT(VARCHAR(5), flight_time, 108) AS Time, flight_number AS Flight FROM flights_table WHERE departure_city = @DepartureCity AND arrival_city = @ArrivalCity AND flight_date BETWEEN DATEADD(DAY, 1, GETDATE()) AND DATEADD(DAY, 20, GETDATE()) ORDER BY flight_date ASC;
Editor is loading...