Re: BUG #1525: wrong time when getting timestamp from date - Mailing list pgsql-bugs

On Fri, 4 Mar 2005, Fran=C3=A7ois LECOMTE wrote:

> Bug reference:      1525
> PostgreSQL version: 8.0.1
> Description:        wrong time when getting timestamp from date field
>=20
> Problem when getting a Java Timestamp object on a DATE database field.
> With driver pg74jdbc3.jar : hours, minutes, seconds and millis have zero
> values (ex : "2003-09-10 00:00:00.0") in the Timestamp object, no problem.
> With driver postgresql-8.0-310.jdbc3.jar (same database, same table, same
> record) : we get 1 hour and zero minutes, seconds and millis ! ("2003-09-=
10
> 01:00:00.0")
> Maybe UTC time ? but suerly a bug...
>=20

There is a known bug in the 8.0 jdbc driver when the client and server are=
=20
in different timezones.  Is that the case here?

Kris Jurka