CURRENT_TIMESTAMP

All functions > METAPROGRAMMING > CURRENT_TIMESTAMP

Returns the current date and time.

Signatures

Returns: The current timestamp at execution time

CURRENT_TIMESTAMP() → TIMESTAMP

Notes

• Returns current date and time as a TIMESTAMP
• Non-deterministic: value changes each time it is evaluated
• Useful for recording when data was processed
• Alias: NOW
• Execution time depends on when the query runs
• Use with caution in features that require reproducibility

Aliases

• NOW

Examples

SELECT
    f1 := EXTRACT(YEAR FROM @literal(CURRENT_TIMESTAMP()))  -- Get current timestamp (non-deterministic, example output)
;