Difference between two times WITH MILLISECONDS

[cswords]

I have an Oracle database which contains a start time and end time (oracle datatype TIMESTAMP). These times contain milliseconds (i.e. HH:MI:SS.SS).

How do I calculate the difference between these two times INCLUDING MILLISECONDS?

I know that DateDiff ("S", startTime, endTime) will return the difference, but it only goes to seconds and I need MILLISECONDS.

Thanks!

 

[Madawc]

I think you'll need to treat the date-time as a string, extract the milliseconds and then make a separate calculation. Find the difference to the nearest second, then adjust manually based on the milliseconds.

Madawc Williams (East Anglia, UK)