The CURRENT_TIMESTAMP function returns the current date and time in the session time zone, as a value of data type TIMESTAMP_TZ. The time zone offset reflects the current local time of the session.
When you want to retrieve the current date and time in the session time zone as a TIMESTAMP value, use the LOCALTIMESTAMP function.
TIMESTAMP_TZ
CURRENT_TIMESTAMP [ (precision) ]
The fractional second precision of the time value returned. When you omit this argument, then the function uses a default value of 6.