PostgreSQL BugTool Submission
PostgreSQL Bugs List <pgsql-bugs@postgresql.org>
From: pgsql-bugs@postgresql.org
To: pgsql-bugs@postgresql.org
Date: 2000-08-23T16:59:55Z
Lists: pgsql-bugs
Gregg Wonderly (gregg@c2-tech.com) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description JDBC driver broken for ResultSet.getTimeStamp() Long Description The JDBC driver in 7.0.2 uses Timestamp.toString() to create the string representation of the timestamp to store into postgresql. It should use Timestamp.valueOf(String) to go back to the native Timestamp value. However, it uses SimpleDateFormat.parse() instead and this will not work correctly. Parse Exceptions occur and the data can not be retrieved from the database as a Timestamp. Sample Code No file was uploaded with this report