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)
Thread:
Lists: pgsql-general
    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 ?


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. 



In response to

Responses

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-2017 The PostgreSQL Global Development Group