0

hi.. iam developing a jsp application. Iam using two columns called open_time and resolution_time. The thing I want is the time difference between two dates but iam unable to do so. please guide me accordingly. Iam using timestamp for the date & time.

2
Contributors
1
Reply
12
Views
4 Years
Discussion Span
Last Post by LastMitch
0

hi.. iam developing a jsp application. Iam using two columns called open_time and resolution_time. The thing I want is the time difference between two dates but iam unable to do so. please guide me accordingly. Iam using timestamp for the date & time.

Do you have at least a code to work on, if so post it.

You can read these articles and it also has a code snippet for you to practice or used.

http://www.htmlgoodies.com/html5/javascript/calculating-the-difference-between-two-dates-in-javascript.html#fbid=104a_oSQFD7

http://psoug.org/snippet/Javascript-Calculate-time-difference-between-two-dates_116.htm

If that's not what you are looking for then please explain a little more.

It seems it also involves the database. So I think it's best if you can post your code. There's no straight answer for this because it involve the database which means a query to Insert the data.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.