Reference material for CURRENT_TIMESTAMP function
TIMESTAMPTZ
NOW
CURRENT_TIMESTAMP CURRENT_TIMESTAMP()
2023-03-03 14:42:31.123456 UTC
SET time_zone = 'Europe/Berlin'; SELECT CURRENT_TIMESTAMP; --> 2023-03-03 15:42:31.123456+01 SET time_zone = 'America/New_York'; SELECT CURRENT_TIMESTAMP; --> 2023-03-03 09:42:31.123456-05