Re: JDBC Timestamp problem

Quoting Antonio Fiol <fiol(at)w3ping(dot)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(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/