Re: [INTERFACES] ResultSet.getDate

From: Peter Mount <peter(at)retep(dot)org(dot)uk>
To: Tim Joyce <tim(at)hoop(dot)co(dot)uk>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] ResultSet.getDate
Date: 1999-09-23 06:21:00
Message-ID: Pine.LNX.4.10.9909230719270.7540-100000@maidast.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Wed, 22 Sep 1999, Tim Joyce wrote:

> Hi,
>
> I am using JDBC, everything is fine on local boxes (GMT), but we have just
> installed our system on a box in the states (EST)
>
> I am getting
>
> java.sql.SQLException: Bad Timestamp Format: at 0 in 1999-07-31 20:00:0EST
>
> thrown by ResultSet
>
> Running Postgresql 6.4.2 on RH Linux 2.0.33
>
> is there a fix or a workarround?

The date and time methods are being rewritten for 6.6 as they can't handle
some of the different time zones.

Peter

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Page 1999-09-23 08:15:33 Re: [INTERFACES] Changing User Passwords
Previous Message Adam Haberlach 1999-09-23 05:46:53 unsubscribe