CURRENT_TIMESTAMP

All functions > DATE_AND_TIME > CURRENT_TIMESTAMP

[Non-deterministic] Returns the current date and time.

Syntax

CURRENT_TIMESTAMP()
sql

Arguments

ParameterTypeRequiredDescription

Returns

The current timestamp at execution time

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

Suggest changes to this page
Last update at: 2025/10/13 10:23:46