LOCALTIMESTAMP
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:
LOCALTIMESTAMP
LOCALTIMESTAMP()
Return Type
TIMESTAMP
Remarks
The function gets the current timestamp from the system, converts it to the time zone specified in the time_zone
setting, and returns it as a TIMESTAMP
value.
Example
The following example assumes that the current timestamp is 2023-03-03 14:42:31.123456 UTC
. Observe how it returns different TIMESTAMP
values for different time zone settings:
SET time_zone = 'Europe/Berlin';
SELECT LOCALTIMESTAMP; --> 2023-03-03 15:42:31.123456
SET time_zone = 'America/New_York';
SELECT LOCALTIMESTAMP; --> 2023-03-03 09:42:31.123456