>The SECONDS() functions has resolution of 10 milliseconds, DATETIME() only 1 second.
>
>>DATETIME() doesn't have that limitation...
>>
>>>No, AFAIK, but you can use SECONDS() function to calculate it. This way you can measure duration of any process, not just SQL Select
ltStart = DATETIME()
>>>SELECT ....
>>>lnTotalSeconds= DATETIME() - ltStart
Just remember that SECONDS() returns number of seconds since midnight. Add 86400 if your process croses midnight. lnTotalTime will be negative number in this case.
Good point. The testing I do usually doesn't require that kind of accuracy, though :-)
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up