Re: BUG #1073: JDBC "time with time zone" - Mailing list pgsql-bugs

> Bug reference:      1073
> Logged by:          Bob Messenger
> Email address:      bob@cassiancapital.com
> 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