Re: [GENERAL] How to get correct local time

2017-03-29 Thread Adrian Klaver
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? Usi

Re: [GENERAL] How to get correct local time

2017-03-29 Thread Vitaly Burovoy
On 3/29/17, Vitaly Burovoy wrote: > On 3/29/17, 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 ? >> >> >> Using >> >> "PostgreSQ

Re: [GENERAL] How to get correct local time

2017-03-29 Thread Vitaly Burovoy
On 3/29/17, 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 ? > > > Using > > "PostgreSQL 9.6.0, compiled by Visual C++ build 1800, 32-bit" >