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.
Neha290791 0 Newbie Poster
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://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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.