From: Geoff Healey <geoff_healey@bigpond.com>
To: Chris Ryan <chris@greatbridge.com>
To: pgsql-interfaces@postgresql.org
Subject: removal from mailing list
Date: Sun, 6 Aug 2000 21:29:33 +1000
Message-ID: <000a01bfff99$98851180$0146a8c0@argentpn.telstra.com.au> (raw)
References: <398C07F5.FE194B49@greatbridge.com>
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@greatbridge.com>
To: <pgsql-interfaces@postgresql.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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: geoff_healey@bigpond.com, chris@greatbridge.com
Subject: Re: removal from mailing list
In-Reply-To: <000a01bfff99$98851180$0146a8c0@argentpn.telstra.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox