filter flights by arrival Time

Question

1.00/5 (1 vote)

See more:

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

Posted 6-Dec-12 20:37pm

bado2015

Updated 11-Dec-12 14:58pm

Jibesh

v2

Add a Solution

Comments

Mehdi Gholam 7-Dec-12 2:41am

You have to supply more information, as your question is too generic to answer.

bado2015 7-Dec-12 3:19am

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

Richard MacCutchan 7-Dec-12 5:14am

You do not say where you are getting your data from, but it is a simple matter to compare the time of the flight to the time selected by the user, and then only display the ones that match.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jibesh · Answer 1 · 2012-12-11T15:03: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.