Categories:: Context functions (Session)

CURRENT_TRANSACTION¶

Returns the transaction id of an open transaction in the current session.

See also:: LAST_TRANSACTION , DESCRIBE TRANSACTION

Syntax¶

CURRENT_TRANSACTION()

Arguments¶

None.

Examples¶

This shows the transaction ID of the current transaction:

SELECT CURRENT_TRANSACTION();
Output:
+-----------------------+
| CURRENT_TRANSACTION() |
|-----------------------|
| 1661899308790000000   |
+-----------------------+