Skip site navigation (1) Skip section navigation (2)

removal from mailing list

From: "Geoff Healey" <geoff_healey(at)bigpond(dot)com>
To: "Chris Ryan" <chris(at)greatbridge(dot)com>, <pgsql-interfaces(at)postgresql(dot)org>
Subject: removal from mailing list
Date: 2000-08-06 11:29:33
Message-ID: 000a01bfff99$98851180$0146a8c0@argentpn.telstra.com.au (view raw or flat)
Thread:
Lists: pgsql-interfaces
Dear all,

Can some one let me know how I can be removed from this mailing list?

Regards

Geoff
----- Original Message ----- 
From: Chris Ryan <chris(at)greatbridge(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Sent: Saturday, August 05, 2000 10:26 PM
Subject: [INTERFACES] JDBC and Timestamps


> I'm working on a project where I update/insert/select records through
> JDBC and I'm noticing problems with the timestamp fields. The JDBC
> driver when writing a Timestamp value to postgres is passing the value
> to the backend as a String in the following format "yyyy-mm-dd
> hh:mm:ss.fffffffff" <-- the last part .fffffffff is nanosecs. When
> Postgres reads this is things it is millisecs so converts it and appends
> the timezone. Now when the JDBC driver reads the value back in it is
> trying to do a date conversion from a string using the format
> "yyyy-mm-dd hh:mm:sszzz" which has timezone but no millisecs. The
> different formats of course cause exceptions to be generated. I tried
> using the setLenient(true) but this didn't make any difference.
> 
> Chris Ryan
> 


In response to

pgsql-interfaces by date

Next:From: Mike EngelhartDate: 2000-08-06 18:16:55
Subject: PostgresqlDataSource
Previous:From: Thomas LockhartDate: 2000-08-05 23:30:10
Subject: Re: JDBC and Timestamps

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group