Thread: Problem Postgres 6.3 and timestamp/date

Problem Postgres 6.3 and timestamp/date

From
"Hahnen, Holger"
Date:
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

Re: Problem Postgres 6.3 and timestamp/date

From
Dave Cramer
Date:
Sorry, you will need to upgrade, any success with a version more than 2
behind the current version (7.3) is pure luck.

Dave
On Tue, 2003-08-19 at 05:02, Hahnen, Holger wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
--
Dave Cramer <Dave@micro-automation.net>