Reference material for LOCALTIMESTAMP function
Returns the current local timestamp in the time zone specified in the session’s timezone
setting.
The function can be called with or without parentheses:
TIMESTAMP
The function gets the current timestamp from the system, converts it to the time zone specified in the timezone
setting, and returns it as a TIMESTAMP
value.
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: