Re: Problem Postgres 6.3 and timestamp/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@xxxxxx
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 
-- 
Dave Cramer <Dave@xxxxxxxxxxxxxxxxxxxx>


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster