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