From: Tim Joyce <tim@hoop.co.uk>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ResultSet.getDate
Date: Mon, 15 Nov 1999 19:58:25 -0000
Message-ID: <012901bf2fa3$d25c43e0$0501a8c0@noonoo> (raw)
References: <18293.942678010@sss.pgh.pa.us>
> "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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tim@hoop.co.uk, tgl@sss.pgh.pa.us
Subject: Re: [INTERFACES] ResultSet.getDate
In-Reply-To: <012901bf2fa3$d25c43e0$0501a8c0@noonoo>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox