User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 422,641 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,713 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums

i need help in my query

Join Date: Jan 2008
Posts: 13
Reputation: wolverine_ramir is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
wolverine_ramir wolverine_ramir is offline Offline
Newbie Poster

i need help in my query

  #1  
Feb 18th, 2008
i need help in my query..

i need to compute for the difference between two time.. i already have a formula for that but the problem is, i am setting up a condition before i get the difference between two diffrenet time...

i have a table named test.. it has 3 columns.. first column says start time, 2nd says end time.. columns 1 and 2 contains the time in hour:minutes:seconds.... the third one is about event id... this event id contains various number codings... the condition is if my event id is equal to 3, i must find another event id which is equal to 5... then i'll get the start time of event id 3 subtract it with the end time of event id 5 to get the time difference in seconds regardless how big the time may be... still it must be displayed in seconds..

i need a condition for getting their time difference with that condition.. i need the result to be displayed on my jsp so that with that query, i won't find any loading time issues.. thanks...
AddThis Social Bookmark Button
Reply With Quote  
All times are GMT -4. The time now is 3:30 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC