Skip to main content
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

Alias calling form: GETDATE

Variable result: The value depends on the query start; repeated calls share that query’s stored instant.
Last modified on October 15, 2026