Hi,

I have to find the difference of timestamp values in microseconds.
Is there any function available that does this job ?

I have search for same, but got no luck.
Thanks in advance.

maybe this can help
DB2 Basics: Fun with Dates and Times

Hi,

Thanks for the reply.
I have allready checked the link. But there is nothing mentioned for microseconds there. It has shown function for getting difference in seconds.

But I am not able to deduce function for finding the difference in microseconds.

Can you help me?

use 1 for the first arguement to the function TIMESTAMPDIFF which means microseconds.

but, would also suggenst looking in the appropriate version of the sql reference for guidance.

micorsecond results in microseconds + seconds + minutes (each of which is converted to microseconds.

probably be better off, removing the hours and minutes portion which calculating invoking the function for microseconds.
assuming that it is ALWAYS the same day,
you would have one SQL, with several SETS, one for function 1, one for 2, one for 4 and one for 8,
removing from each the micro/sec/min/hours.
if you are confused, read the manual and try a few selects.

Examples of microseconds difference are in here. (Not only milliseconds diff.)
Number of miliseconds between now and ...
Number of milliseconds between two timestamps - IBM DB2