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

RE: JDBC and Timestamps

From: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
To: "'Chris Ryan'" <chris(at)greatbridge(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: RE: JDBC and Timestamps
Date: 2000-08-05 13:20:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
This should already be fixed in cvs.


Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council

-----Original Message-----
From: Chris Ryan [mailto:chris(at)greatbridge(dot)com]
Sent: Saturday, August 05, 2000 1:26 PM
To: pgsql-interfaces(at)postgresql(dot)org
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


pgsql-interfaces by date

Next:From: Thomas LockhartDate: 2000-08-05 23:30:10
Subject: Re: JDBC and Timestamps
Previous:From: Chris RyanDate: 2000-08-05 12:26:29
Subject: JDBC and Timestamps

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