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
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 |