> "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