RE: Retrieve the server's time zone

> 
> From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer
> Sent: Dienstag, 21. November 2017 12:30
> To: Thomas Kellerer <spam_eater@gmx.net>
> Cc: List <pgsql-jdbc@postgresql.org>
> Subject: Re: Retrieve the server's time zone
> 
> It is in the session startup messages. I'm trying to recall the technical details as to why. My recollection is that
fortimestamps without timezone will be reported in the client timezone.
 
> 
> Do you want the server timezone or postgres timezone. A simple C function should provide the latter.

Hello,
As a workaround, you could add your own GUC variable "myServerTimeZone" 
regards,
Marc Mamin


> 
> Dave Cramer
> 
> davec@postgresintl.com
> www.postgresintl.com
> 
>> On 21 November 2017 at 02:01, Thomas Kellerer <spam_eater@gmx.net> wrote:
>> Hello,
>> 
>> it seems the JDBC driver (or Java?) makes it impossible to retrieve the server's time zone.
>> 
>> Apparently the driver changes the timezone setting so that it can't be reset to the original from the server.
>> 
>> When I run "show timezone" from within JDBC I *always* get the client's time zone, even if I do a "reset timezone"
beforethat
 
>> 
>> When I do the same with psql I can see the server's time zone.
>> 
>> Ultimately I would like to get the server's time, e.g. by running something like:
>> 
>>    select current_timestamp at time zone server_timezone
>> 
>> I already posted this to the general mailing list, because I initially thought this was a Postgres problem.
>> Tom Lane suggested, I could see the original time zone the server is set up with using:
>> 
>>    select reset_val from pg_settings where name = 'TimeZone';
>> 
>> But that again returns the client's time zone through JDBC, but the real time zone through psql.
>> 
>> It seems the driver changes this setting permanently for the session.
>> If that is the case, can I prevent that somehow?
>> 
>> Thomas
>> 
> 
>