Re: JDBC date problem

> 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