NOW

​

Syntax

​

Now default (scalar)

now()

​

Arguments

​

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: NOW

SELECT now() AS result;