ELAPSEDTRANSACTIONTIME() SQL Function

ELAPSEDTRANSACTIONTIME() returns the amount of time in seconds that elapsed since the current transaction started. A transaction starts when a record is locked (for example when starting updating a record), or otherwise when a data manipulation statement (insert, update, delete) is sent to the database.

The elapsed transaction time is set back to zero when a commit or rollback takes place.

The ELAPSEDTRANSACTIONTIME() function requires no parameters:

SELECT    ELAPSEDTRANSACTIONTIME()

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