> Bug reference: 1073 > Logged by: Bob Messenger > Email address: [EMAIL PROTECTED] > Description: JDBC "time with time zone" > > Details: > > create table a(b time with time zone); > > insert into a values ('00:00:00'); > > System.out.println(rs.getTimestamp(1)); > > Exception in thread "main" org.postgresql.util.PSQLException: Bad Timestamp > Format at 2 in 00:00:00+00
I have confirmed this bug. getTimestamp handles neither time nor timetz, getTime also does not handle timetz. The fix for this is a little complicated as the date/time/timestamp parsing is kind of messy, but I will try to have a patch for this sometime this weekend. Kris Jurka ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]