Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group