Documentation

    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 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.