Hello,
select TZ_OFFSET ('US/Eastern') from dual ;
it's returning in oracle
----------------------------------
-04:00
but in postgres
select TZ_OFFSET ('US/Eastern');
its'returning like function tz_offset('us/Eastern') does not exist;
let me know how to solve issue