Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA09143 for ; Mon, 15 Nov 1999 10:01:22 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA18295; Mon, 15 Nov 1999 10:00:10 -0500 (EST) To: "Tim Joyce" cc: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] ResultSet.getDate In-reply-to: Your message of Mon, 15 Nov 1999 11:29:20 -0000 <01a501bf2f5c$b6f9e3b0$0501a8c0@noonoo> Date: Mon, 15 Nov 1999 10:00:10 -0500 Message-ID: <18293.942678010@sss.pgh.pa.us> From: Tom Lane "Tim Joyce" writes: > But how do I set the timezone when I start postgres so that dates are always > reported in GMT? TZ when the postmaster is started sets the default zone, I believe. There is no way to make it "always" report in GMT, if by that you mean overriding clients' PGTZ settings. regards, tom lane