how do I get the start and end time for a transaction?
MeasureGet("sql1execute", MEASURE_TIMER_RESPONSETIME, MEASURE_KIND_SUM, fValueExec);
will get me the elapsed time. But how do I get the start and end timestamp for a transaction?
oops - I didn't know about the GetTimeStamp() function!
Glad to see you got it sorted ....
If you need more help just shout
Select Red Ltd
actually Martin - I do have another question..
is there a way to get a more precise timestamp including milliseconds? e.g. HH:MM:SS:MS. The getcurrentdate() only gets up to seconds.
from my memory john im not sure ....
have a search through the help .... im sure you will find the answer there.
just watch out that your system clock is set correctly and not with daylight saving.
Try it with TIMESTAMP_IN_MS