displaying milliseconds in report (%H:%i:%S & %ms)

[rajuchacha007]

Hello Experts,

I am designing a report to display some data details. While displaying those details, I need to display time difference between two data processing. There fore, in my query I am writing following to get time difference.

select

 data.START_DATETIME,
     data.END_DATETIME,

TIME_FORMAT(TIMEDIFF(data.end_datetime, data.start_datetime),'%H:%i:%S') as execute_time

from

FROM
     data

 

My concern is to display miliseconds. I am not able to display milliseconds. Is it possible to display milliseconds using only query or should I need to write java expression in ireport? If yes, Under expression tab from text field properties, I couldn't find Date() function as such? What should I have to do in order to get time difference in milliseconds as well? Please guide/suggest/advise. Thanks in advance.

Post Edited by rajuchacha007 at 07/24/2010 09:12

[rajuchacha007]

Ok. I did like '%H:%i:%S:%ms'. It shows milliseconds digits although it is not legal syntax of the query but it is working for the time being. Not sure this ms stands for milli or micro seconds.

Thanks

Post Edited by rajuchacha007 at 07/24/2010 10:46