TZ_OFFSET

TZ_OFFSET returns the time zone offset of a specified time zone relative to Greenwich Mean Time (GMT).

Syntax

TZ_OFFSET(n)

Parameter	Description
`n`	The name of the time zone whose offset you want to retrieve.

To list all valid time zone region names, run:

SELECT * FROM pg_timezone_names;

SELECT TZ_OFFSET('Antarctica/Syowa');

Output:

 tz_offset
-----------
 +03:00
(1 row)

Antarctica/Syowa is 3 hours ahead of GMT.

SELECT TZ_OFFSET('US/Eastern');

Output (standard time):

 tz_offset
-----------
 -05:00
(1 row)

US/Eastern is 5 hours behind GMT during standard time.