Re: BUG #1073: JDBC "time with time zone"

From: Kris Jurka <books(at)ejurka(dot)com>
To: <bob(at)cassiancapital(dot)com>
Cc: PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1073: JDBC "time with time zone"
Date: 2004-02-06 13:32:41
Message-ID: Pine.LNX.4.33.0402060824520.21608-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> Bug reference: 1073
> Logged by: Bob Messenger
> Email address: bob(at)cassiancapital(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2004-02-06 14:11:00 plperl problem
Previous Message Achilleus Mantzios 2004-02-06 08:13:25 Re: IN does not negate, exists does