Skip site navigation (1) Skip section navigation (2)

How to get correct local time

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: How to get correct local time
Date: 2017-03-29 10:03:40
Message-ID: 49EECE30EBB14603AA9799B439528F7E@dell2 (view raw, whole thread or download thread mbox)
Lists: pgsql-general
    select current_time at time zone 'GMT-2'



but correct local time in Windows is one hour different:


How to get correct local time ?


"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


In response to


pgsql-general by date

Next:From: Vitaly BurovoyDate: 2017-03-29 10:56:19
Subject: Re: How to get correct local time
Previous:From: Karsten HilbertDate: 2017-03-29 09:37:15
Subject: Re: Postgres Permissions Article

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group