Received: from ganesh.paneris.org (IDENT:root@paneris.org [194.128.98.74])
	by hub.org (8.9.3/8.9.3) with ESMTP id PAA53897
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 15 Nov 1999 15:00:48 -0500 (EST) (envelope-from tim@hoop.co.uk)
Received: from noonoo (flav1.dircon.co.uk [194.112.47.31])
	by ganesh.paneris.org (8.8.7/8.8.7) with SMTP id TAA29133;
	Mon, 15 Nov 1999 19:52:34 GMT
Message-ID: <012901bf2fa3$d25c43e0$0501a8c0@noonoo>
From: "Tim Joyce" <tim@hoop.co.uk>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-interfaces@postgreSQL.org>
References: <18293.942678010@sss.pgh.pa.us>
Subject: Re: [INTERFACES] ResultSet.getDate 
Date: Mon, 15 Nov 1999 19:58:25 -0000
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300



> "Tim Joyce" <tim@hoop.co.uk> 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.

thanks, but what is then the best way of avoiding the following exception:

java.sql.SQLException: Bad Timestamp Format: at 0 in 1999-11-12 17:36:5EST

cheers

timj