My database contain SCH_TIME in the following format ie numeric
SCH_ TIME
1000
1015
1150
1215
I need fo filter the SCH_TIME from the system time so the particular time what are the flight are avalable
So I write the following query
[WOS].[COG_RPT_DATA].[SCH_TIME]=to_char({sysdate},'HH24MI')
& that's work fine but when I want to display the next 5 hours flight details how to modify the query .