Re: Problem Postgres 6.3 and timestamp/date - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Problem Postgres 6.3 and timestamp/date
Date
Msg-id 1061294674.5628.52.camel@localhost.localdomain
Whole thread Raw
In response to Problem Postgres 6.3 and timestamp/date  ("Hahnen, Holger" <Holger.Hahnen@dfg.de>)
List pgsql-jdbc
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>


pgsql-jdbc by date:

Previous
From: "Hahnen, Holger"
Date:
Subject: Problem Postgres 6.3 and timestamp/date
Next
From: Barry Lind
Date:
Subject: Re: odd behaviour of prepared statement