get_current_timestamp
Return the current date and time, with time zone.
Also available as now, transaction_timestamp.
Try an expression
In Formula, enter the expression and set Output type to TIMESTAMP WITH TIME ZONE.
Expression
get_current_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
get_current_timestamp()Supported signatures (1)
get_current_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.