The following bug has been logged online: Bug reference: 1525 Logged by: François LECOMTE Email address: [EMAIL PROTECTED] 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... ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match