LOCALTIMESTAMPNTZ

Returns the current local timestamp in the time zone specified in the session’s time_zone setting.

Syntax

The function can be called with or without parentheses:

LOCALTIMESTAMPNTZ
LOCALTIMESTAMPNTZ()

Return Type

TIMESTAMPNTZ

Remarks

The function takes the current Unix timestamp (in the UTC time zone), converts it to the time zone specified in the time_zone setting, and returns it as a TIMESTAMPNTZ value. Two simultaneous calls of the function can return different timestamps, due to time zone conversion.

Example

The following example assumes that the current timestamp is 2023-03-03 14:42:31.123456 UTC.

Observe how we return different TIMESTAMPNTZ values with different time zone settings:

SET time_zone = 'Europe/Berlin';
SELECT LOCALTIMESTAMPNTZ;  --> 2023-03-03 15:42:31.123456

SET time_zone = 'America/New_York';
SELECT LOCALTIMESTAMPNTZ;  --> 2023-03-03 09:42:31.123456