Re: [INTERFACES] ResultSet.getDate

From: "Tim Joyce" <tim(at)hoop(dot)co(dot)uk>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] ResultSet.getDate
Date: 1999-11-15 19:58:25
Message-ID: 012901bf2fa3$d25c43e0$0501a8c0@noonoo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> "Tim Joyce" <tim(at)hoop(dot)co(dot)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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tatsuo Ishii 1999-11-16 02:26:53 Re: [INTERFACES] Japanese, Java and Postgres
Previous Message Ashish Sharma 1999-11-15 17:36:57 Japanese, Java and Postgres