按到达时间过滤航班 [英] filter flights by arrival Time

问题描述

我需要在到达时间过滤机票时间



当我点击过滤器并输入例如12 Am

获得所有到达的航班12 Am



如果您有抵达时间的航班表

例如：航班号地点时间

205伦敦12日上午

708德国2 Pm

901土耳其早上5点

1001埃及5上午

1015印度2 Pm



如果我输入下午2点，我会按时间过滤

显示航班德国和印度



如果输入5 Am

显示航班埃及和土耳其

I need Filter Flights by arrival Time

when I click filter and enter for example 12 Am
get all flights that arrive on 12 Am

if u have table for flight with arrival time
e.g : flight number place time
205 London 12 am
708 German 2 Pm
901 Turkey 5 am
1001 Egypt 5 Am
1015 India 2 Pm

I wand to filter by time if I enter 2 pm
show flight German and India

if enter 5 Am
show flight Egypt and Turkey

推荐答案

select * from flightTable where arrivalTime ='' inputarrivaltime''按航班号命令



select * from flightTable where time =''2012/12/11 14:00:00按航班号命令



输出

------



708德语2012/12/11 14:00:00

1015印度2012/12/11 14:00:00



根据您的过滤器在查询中也包括日期。

select * from flightTable where arrivalTime = ''inputarrivaltime'' order by flightnumber

select * from flightTable where time = ''2012/12/11 14:00:00" order by flightnumber

output
------

708 German 2012/12/11 14:00:00
1015 India 2012/12/11 14:00:00

do include the date too in your query based on your filter.

这篇关于按到达时间过滤航班的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！