The LOCALTIMESTAMP function returns the current date and time in the session time zone as a value of data type TIMESTAMP
.
When you want to retrieve the current date and time in the session time zone as a TIMESTAMP_TZ
value, use the CURRENT_TIMSTAMP function.
TIMESTAMP
LOCALTIMESTAMP [ (timestamp-precision) ]
Specifies the fractional second precision of the time value returned