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

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

pgsql-interfaces by date

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

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