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.
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