On 20/01/16 15:38, Steve Crawford wrote: > Is this of any use? > > select * from pg_timezone_names where name = 'Europe/Lisbon'; > name | abbrev | utc_offset | is_dst > ---------------+--------+------------+-------- > Europe/Lisbon | WET | 00:00:00 | f >
A bit - but what's missing is to know if daylight savings is in effect. So it could be WET or WEST so we need a date time and an TZ to work it out. Steve -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
