If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

system time

Started by esanray, 23 Nov 2011 12:18:22 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

esanray

23 Nov 2011 12:18:22 AM
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 .

Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite