Scalar function
Aliases: getdate, now
The result is non-NULL. NULL or invalid timezone strings select UTC.
Syntax
Default (scalar)
Timezone (scalar)
Getdate default (scalar)
Now default (scalar)
Arguments
default, getdate default, now default: Takes no arguments.
Timezone
Returns
- Type: TIMESTAMP with a time zone
- NULL behavior: The result is non-NULL. NULL or invalid timezone strings select UTC.
Properties
Usage notes
-
The time-zone argument changes the result’s time zone without changing the instant it represents.
-
Deterministic: The time differs between queries but is fixed during each query.
Examples
Query-start instant
Variable result: The value depends on the query start; repeated calls share that query’s stored instant.
Variable result: The value depends on the query start; repeated calls share that query’s stored instant.
Variable result: The value depends on the query start; repeated calls share that query’s stored instant.Last modified on October 15, 2026
