Date and time functions
LOCALTIMESTAMP
Reference material for LOCALTIMESTAMP function
Returns the current local timestamp in the time zone specified in the session’s timezone
setting.
Syntax
The function can be called with or without parentheses:
Return Type
TIMESTAMP
Remarks
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.
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: