Reference material for AGO function
TIMESTAMPTZ
AGO(<interval>)
<interval>
interval
2023-03-03 14:42:31.123456 UTC
SET time_zone = 'Europe/Berlin'; SELECT CURRENT_TIMESTAMP; --> 2023-03-03 15:42:31.123456+01 SELECT AGO('1h'); --> 2023-03-03 14:42:31.123456+01