Forums Register Login

joda api calculating difference between two dates including milliseconds.

+Pie Number of slices to send: Send
Experts,

I am looking to calculate difference between two dates including milliseconds. I have gone through JODA API. I have a report as an output in ireport. I am executing it witihn a java now. I want to display difference between two dates including milliseconds. Initially, I changed the query to "TIME_FORMAT(TIMEDIFF(process1.end_datetime, process1.start_datetime),'%H:%i:%S%f') as exec_time". Later I tried to import joda-time-1.6.1.jar in the ireport itself. It didn't work. In a simple date difference program, how could I achieve this? Once I find the way to calculate difference including milliseconds, I would import same technique in the report later. Has anyone worked on this earlier? I would appreciate your suggestions/ideas. Thank you in advance. Following is my current output. On the RunTime i want to include milliseconds as well.

ID StepName StartTime EndTime RunTime Status
3 Process1 2010-08-09 02:08:00 AM 2010-08-09 02:08:01 AM 00:00:01 Success
4 Process2 2010-08-09 02:08:01 AM 2010-08-09 02:15:00 AM 00:06:59 Success


Best regards.
+Pie Number of slices to send: Send
Experts ant suggestions/advice please?
+Pie Number of slices to send: Send
Did you find this page?
The overall mission is to change the world. When you've done that, then you can read this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 2700 times.
Similar Threads
Calculate date difference [Gregorian calender]
10000 milliseconds showing as 01:00:10.000 - why ?
oracle date between
dates between two dates
difference between two timestamps
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 03:16:40.