From: | Holger Klawitter <holger(at)klawitter(dot)de> |
---|---|
To: | "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | bug?: java won't read timestamps |
Date: | 2001-06-06 16:24:23 |
Message-ID: | 3B1E5937.4132D6D7@klawitter.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi there,
I have a table containing "timestamp with time zone" and I observed
a strange problem:
THE ENVIRONMENT:
Linux 2.4.0
Postgres 7.1.2
JDK 1.3.1 (same with JDK 1.3.0)
postgresql.jar from $PGHOME/share/java
THE TABLE:
Table "hits"
Attribute | Type | Modifier
--------------+--------------------------+----------
id | integer |
zeit | timestamp with time zone |
THE PROGRAM:
stmt = toDB.createStatement();
ResultSet rs = stmt.executeQuery( "SELECT max(zeit) FROM hits" );
rs.next();
ts = rs.getTimestamp(1); // <-- breaks here
stmt.close();
THE ERROR:
Bad Timestamp Format at 19 in 2001-03-05 17:17:13.24+01
The second fraction seems not to be supported by the jdbc timestamp
reader. BTW: there is no format specifier for them as well (at least
in the docs).
I am helping myself by forcing a different output
to_char(max(zeit),"YYYY-MM-DD HH24:MI:SS+01")
Is there a better solution?
(Is the relevant code in java.sql or is it in org.postgresql?)
With kind regards / Mit freundlichem Gruß
Holger Klawitter
--
Holger Klawitter
holger(at)klawitter(dot)de http://www.klawitter.de
From | Date | Subject | |
---|---|---|---|
Next Message | Fran Fabrizio | 2001-06-06 16:52:13 | "trigger"ing a procedure every X minutes |
Previous Message | Martín Marqués | 2001-06-06 16:12:46 | Re: [HACKERS] something smells bad |