Postgres and timezones

From: Steve Rogerson <steve(dot)pg(at)yewtc(dot)demon(dot)co(dot)uk>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Postgres and timezones
Date: 2016-01-20 11:10:53
Message-ID: 569F6B3D.2000103@yewtc.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, this is wrong:

# select to_char('2016-01-20 00:00'::timestamp at time zone 'Europe/Lisbon',
'TZ');
to_char
---------
GMT
(1 row)

It should be WET, "Western European Time". Is there something I'm doing wrong?

Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sachin Srivastava 2016-01-20 11:42:35 ERROR for '@' for function
Previous Message Pavel Stehule 2016-01-20 10:47:59 Re: Error in Update and Set statement