see timezone in postgres code example

Example 1: storing timezones in postgres

select name from pg_timezone_names where name not like 'posix%' and name not ilike 'system%' order by name;

Example 2: postgresql date at timezone

select updatedat AT TIME ZONE 'UTC';