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.

Member Avatar

LastMitch

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.