> Any ideas? This is a real stumper and I need to find a solution asap! I'm
> using a JDBC driver I built from CVS no more than a month ago.
The results look to me like that in org.postgresql.jdbc2.ResultSet
'mm' and 'MM' have been confused (I know that this was the case in a patch
I submitted), try replacing getTimeStamp() with:
public Timestamp getTimestamp(int columnIndex) throws SQLException { String s = getString(columnIndex);
if(s==null)returnnull;
SimpleDateFormat df = null; if (s.length()>21 && s.indexOf('.') != -1) { df = new
SimpleDateFormat("yyyy-MM-ddHH:mm:ss.SSzzz"); } else if (s.length()>19 && s.indexOf('.') == -1) { df = new
SimpleDateFormat("yyyy-MM-ddHH:mm:sszzz"); } else if (s.length()>19 && s.indexOf('.') != -1) {df = new
SimpleDateFormat("yyyy-MM-ddHH:mm:ss.SS"); } else if (s.length()>10 && s.length()<=18) {df = new
SimpleDateFormat("yyyy-MM-ddHH:mm:ss"); } else { df = new SimpleDateFormat("yyyy-MM-dd"); }
try {return new Timestamp(df.parse(s).getTime()); } catch(ParseException e) {throw new
PSQLException("postgresql.res.badtimestamp",new Integer(e.getErrorOffset()),s); } }
Michael Stephenson
