ELAPSEDQUERYTRANSACTIONTIME() SQL Function

Previous Next

ELAPSEDQUERYTRANSACTIONTIME() returns the amount of time in seconds that elapsed since the first SELECT statement was issued on the database after the last commit or rollback.

The ELAPSEDQUERYTRANSACTIONTIME() function requires no parameters:

SELECT    ELAPSEDQUERYTRANSACTIONTIME()

 

You can use this function for example in the SQL Command dialog.