transaction_timestamp
Return the current date and time, with time zone.
Also available as get_current_timestamp, now.
Try an expression
In Formula, enter the expression and set Output type to TIMESTAMP WITH TIME ZONE.
Expression
transaction_timestamp()Expected behavior
The timestamp at the start of the transaction.Its value varies between executions; the example checks its behavior rather than a fixed value.
Arguments and types
transaction_timestamp()Supported signatures (1)
transaction_timestamp() → TIMESTAMP WITH TIME ZONEThe result type can depend on the input types. See DuckDB for the full argument rules.
Function metadata from DuckDB, used under the MIT license.