RE: JDBC Timestamp Problem

From: Peter Mount <petermount(at)maidstone(dot)gov(dot)uk>
To: "'yves(at)asua(dot)vlaanderen(dot)net'" <yves(at)asua(dot)vlaanderen(dot)net>, pgsql-interfaces(at)postgresql(dot)org
Subject: RE: JDBC Timestamp Problem
Date: 2000-12-11 09:16:15
Message-ID: 1B3D5E532D18D311861A00600865478CF1B649@exchange1.nt.maidstone.gov.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)maidstone(dot)gov(dot)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(at)asua(dot)vlaanderen(dot)net [mailto:yves(at)asua(dot)vlaanderen(dot)net]
> Sent: Saturday, December 09, 2000 1:44 PM
> To: pgsql-interfaces(at)postgresql(dot)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
>

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Stephenson 2000-12-11 10:30:14 Re: JDBC Timestamp Problem
Previous Message Peter Mount 2000-12-11 09:05:10 RE: JDBC Drop/Create problem?