On 03/29/2017 03:03 AM, Andrus wrote:
select current_time at time zone 'GMT-2' returns "11:54:40.22045+02" but correct local time in Windows is one hour different: 12:54 How to get correct local time ?
What time zone are you in? What is the TimeZone set to in postgresql.conf?
Using "PostgreSQL 9.6.0, compiled by Visual C++ build 1800, 32-bit" with standard postgresql.conf file in Windows 10 Same issue occurs also in ealier Postgres and in earlier windows. Server time in Windows is correct. Daylight saving time was changed by one hour a week ago. Maybe postgres didnt recognized it. Posted also in http://stackoverflow.com/questions/43090328/how-to-return-correct-local-time-in-postgres Andrus.
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
