Problem Postgres 6.3 and timestamp/date - Mailing list 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.Hahnen@dfg.de