Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cEI1A-0000yI-Fb for pgsql-interfaces@arkaria.postgresql.org; Tue, 06 Dec 2016 15:50:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cEI1A-0002tG-2O for pgsql-interfaces@arkaria.postgresql.org; Tue, 06 Dec 2016 15:50:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cEI19-0002jL-5s for pgsql-interfaces@postgresql.org; Tue, 06 Dec 2016 15:50:55 +0000 Received: from mx2.logianalytics.com ([209.48.69.18]) by magus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cEI12-0005CA-QI for pgsql-interfaces@postgresql.org; Tue, 06 Dec 2016 15:50:51 +0000 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; s=logi; d=logianalytics.com; h=from:to:subject:date:message-id:content-type:mime-version; bh=KjWRsbNjYszn9W/BTc1QbqHV7Mk=; b=UajLzFBcfSud4EZZV+5UoCmTTjDC2zF/QvMG1NNxKRgkSH9gTi49DGcAffydoNhVNgWc0MUc 8z9HpnFplCcyY2f8yvR806TvXxJpjwteHKJiLRfDVrlW5UpXY4cNDcyvir7K3kUH8UrCKp6l hh8DZJ2H1zHExDZeCWlsMr7YuPo= Received: from LOGIMAIL10.LogiXML.local ([fe80::954a:d9c0:bd7e:8e38]) by LogiMail11.LogiXML.local ([fe80::b5b3:2075:940e:6ea1%16]) with mapi id 14.03.0319.002; Tue, 6 Dec 2016 10:50:31 -0500 From: "Clifton B. Sothoron Jr." To: "pgsql-interfaces@postgresql.org" Subject: User time zone ignored in JDBC/PostgreSql Thread-Topic: User time zone ignored in JDBC/PostgreSql Thread-Index: AdJP1y9Cijjjoqi+RSONycuVLUKBlA== Date: Tue, 6 Dec 2016 15:50:30 +0000 Message-ID: <6A395F497CE89A4693420F1134B3FDB896E4504D@LogiMail10.LogiXML.local> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.192.151] Content-Type: multipart/alternative; boundary="_000_6A395F497CE89A4693420F1134B3FDB896E4504DLogiMail10LogiX_" MIME-Version: 1.0 X-Pg-Spam-Score: -4.9 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-interfaces Precedence: bulk Sender: pgsql-interfaces-owner@postgresql.org --_000_6A395F497CE89A4693420F1134B3FDB896E4504DLogiMail10LogiX_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I've created a user with a time zone of America/Chicago and a server time z= one of America/New York. I run the following query and America/New York is = returned. The user time zone setting is ignored. It doesn't seem to be usab= le via JDBC. select now(), extract(timezone FROM now()), current_setting('TIMEZONE'), no= w()-interval '1 hour' as "1HourAgo" I don't see any documented PostgreSQL JDBC connection properties that cause= the user time zone to be honored. Is there a way to via a JDBC connection = to cause the user time zone to be used? Thanks in advance, Clifton Sothoron Senior Programmer Logi Analytics Inc. --_000_6A395F497CE89A4693420F1134B3FDB896E4504DLogiMail10LogiX_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I’ve created a user with a time zone of Americ= a/Chicago and a server time zone of America/New York. I run the following q= uery and America/New York is returned. The user time zone setting is ignore= d. It doesn’t seem to be usable via JDBC.

select now(), extract(timezone FROM now()), curr= ent_setting('TIMEZONE'), now()-interval '1 hour' as "1HourAgo"

I don’t see any documented PostgreSQL JDBC con= nection properties that cause the user time zone to be honored. Is there a = way to via a JDBC connection to cause the user time zone to be used?

Thanks in advance,

Clifton Sothoron

Senior Programmer

Logi Analytics Inc.

--_000_6A395F497CE89A4693420F1134B3FDB896E4504DLogiMail10LogiX_--