Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group