From: | "Hahnen, Holger" <Holger(dot)Hahnen(at)dfg(dot)de> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Problem Postgres 6.3 and timestamp/date |
Date: | 2003-08-19 09:02:54 |
Message-ID: | D905D3C7984FB74CADDB555EB37C1BF34CDFFD@SRWEP058.int.dfg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi !
I´m trying to get some data from a postgres 6.3 table with the jdbc and jdk1.4.1.
The problem occurs when reading data from date or timestamp fields:
The field is a timestamp. If i use
Timestamp aen_dat = rs.getTimestamp("aen_dat");
i´ll get:
java.sql.SQLException: Bad Timestamp Format: at 18 in 2002-06-30 13:08:0Europe/Paris
and if i use:
Date aen_dat = rs.getDate("aen_dat");
i´ll get:
java.SqlException Bad Date Format: at o in epoch
The same code with rs.getTimestamp works fine in postgres 7.3.
Any ideas ?
Holger Hahnen
-------------------------------------------------------------
Holger Hahnen
Deutsche Forschungsgemeinschaft
Bereich Informationsmanagement
Kennedyallee 40, D - 53175 Bonn
Tel.: (0228) 885-2136 E-Mail: Holger(dot)Hahnen(at)dfg(dot)de
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2003-08-19 12:04:34 | Re: Problem Postgres 6.3 and timestamp/date |
Previous Message | kevin | 2003-08-19 08:23:55 | Re: resultset.first() untrappable error |