Re: JDBC Timestamp problem - Mailing list pgsql-jdbc

From Peter T Mount
Subject Re: JDBC Timestamp problem
Date
Msg-id 982861598.3a95471e36517@webmail.retep.org.uk
Whole thread Raw
In response to JDBC Timestamp problem  (Antonio Fiol <fiol@w3ping.com>)
List pgsql-jdbc
Quoting Antonio Fiol <fiol@w3ping.com>:

> Hello,
>
> I have an application that worked well woth Postgresql 6.5.
>
> Now I am on 7.0, and I get this exception when I execute an
> rs.getTimestamp("reftime"):
>
> Bad Timestamp Format at 0 in 1970-01-01 01:26:56.99+01
>         at
> org.postgresql.jdbc1.ResultSet.getTimestamp(ResultSet.java:445)
>         at
> org.postgresql.jdbc1.ResultSet.getTimestamp(ResultSet.java:587)
>
> Any idea of what it might be ?

Yes, there's been a lot of problems with timestamps, mainly where it was
getting confused with timezone/millisecond variations. 99% of these have been
fixed in the 7.1 driver.

(I say 99% as there is bound to be a senario we've missed out ;-) )

Peter


--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

pgsql-jdbc by date:

Previous
From: Chad David
Date:
Subject: [PATCHES] BlobInputStream.java patch
Next
From: Joseph Shraibman
Date:
Subject: Re: [Fwd: JDBC Timestamp problem]