Documentation

    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 ZONE

    The result type can depend on the input types. See DuckDB for the full argument rules.

    Browse dates & timesDuckDB documentation

    Function metadata from DuckDB, used under the MIT license.