Scalar function
Aliases: current_timestamp
The result is non-NULL.
Syntax
Getdate default (scalar)
Arguments
Takes no arguments. Use CURRENT_TIMESTAMP for the form that accepts a time zone.
Returns
- Type: TIMESTAMP with a time zone
- NULL behavior: The result is non-NULL.
Properties
Usage notes
- Deterministic: The time differs between queries but is fixed during each query.
Examples
Variable result: The value depends on the query start; repeated calls share that query’s stored instant.Last modified on October 15, 2026