I tried the first solution, and I saw that the report is already set up for datetime fields.
some technical information about my problem:
I have a table with some fields
(for this example - 4 fields: date, varchar2(10) and 2 fields of timestamp). My purpose is to find the different between the...
I'm trying to make a report on a table which has fields of timestamp, but when I open the report - I can't see the timestamp fields. Does somebody know how can I get them?
Thank, Dgillz, for your answer, but I have to get the information not rounded and not truncated.
I mean that if 2 dates have different of 2.3 seconds - I want to get 2,300 milliseconds.
If I use your solution - I will get 2,000 milliseconds.
Thanks again, Michal.
Does somebody know how can I get different between to dates in milliseconds?
(I tired to use datediff('ms',date1,date2) and the crystal doesn't get it....)
Thank you, Michal.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.