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