Re: Retrieve the server's time zone

On Tue, 2017-11-21 at 13:44 +0100, Thomas Kellerer wrote:
> Vladimir Sitnikov schrieb am 21.11.2017 um 12:52:
> > Could you please clarify what is the case of "receiving server-side
> > time zone"?
> >
> > For instance: do you need PostgreSQL time zone or OS time zone?
>
> I need a timestamp in the server's time zone. Or at leas the time
> zone of
> the OS. The one that is configured for Postgres on the server would
> do as
> well (in my case that is the server's OS time zone)
>
> E.g.
>
> select localtimestamp
>
> will return the server's local time converted to the *client's* time
> zone in JDBC.
>
> In psql however, it does return the timestamp as "seen" by the
> server.
>
> I could live with getting the server's OS time zone through "show
> timezone"
> because then I could convert current_timestamp back to that time
> zone.
>
> Thomas
>
>
>
>
>
Hi Thomas,

What does java.util.TimeZone.getDefault() return on your server?

As in:- TimeZone timeZone = TimeZone.getDefault();
timeZone.getDisplayName();
timeZone.getID();
timeZone.getOffset( System.currentTimeMillis() );

HTH.
Rob