The following bug has been logged online:
Bug reference: 1525
Logged by: Franois LECOMTE
Email address: francois(dot)lecomte(at)oosphere(dot)com
PostgreSQL version: 8.0.1
Operating system: Linux Debian
Description: wrong time when getting timestamp from date field
Details:
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...