RE: JDBC Timestamp Problem - Mailing list pgsql-interfaces

From Peter Mount
Subject RE: JDBC Timestamp Problem
Date
Msg-id 1B3D5E532D18D311861A00600865478CF1B649@exchange1.nt.maidstone.gov.uk
Whole thread Raw
In response to JDBC Timestamp Problem  (yves@asua.vlaanderen.net)
List pgsql-interfaces
What version of the driver are you using? This particular bug should have
gone long ago (~7.0)

Peter

-- 
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council


> -----Original Message-----
> From: yves@asua.vlaanderen.net [mailto:yves@asua.vlaanderen.net]
> Sent: Saturday, December 09, 2000 1:44 PM
> To: pgsql-interfaces@postgresql.org
> Subject: [INTERFACES] JDBC Timestamp Problem
> 
> 
> Hello,
> 
> I have a problem with timestamps and JDBC-Postgresql
> 
> It seems that the JDBC-driver doesn't parse all 
> representations of timestamps.
> I calculate my own Timestamp and insert it into a table.
> The field seems to contain (with psql SELECT):
> 
> 2000-12-06 00:05:39.57+01
> 
> When i try to use a res.getTimestamp(i) i get an unparseable 
> Timestamp exception at position 19
> 
> When i use a now() value the field contains (with psql SELECT):
> 
> 2000-12-07 11:42:36+01
> 
> I get the impression that either there is a representation 
> issue with postgresql or there is a small problem with the 
> JDBC driver or i'm doing something wrong :-)
> 
> Greetz,
> 
> Yves De Muyter
> 


pgsql-interfaces by date:

Previous
From: Michael Stephenson
Date:
Subject: Re: JDBC Timestamp Problem
Next
From: Peter Mount
Date:
Subject: RE: JDBC Drop/Create problem?