Received: from mail.retep.org.uk ([216.126.85.184]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2L9Dtt55894 for ; Wed, 21 Mar 2001 04:14:01 -0500 (EST) (envelope-from peter@retep.org.uk) Received: (from nobody@localhost) by mail.retep.org.uk (8.11.3/8.11.1) id f2L9CTE55863; Wed, 21 Mar 2001 04:12:29 -0500 (EST) (envelope-from peter@retep.org.uk) X-Authentication-Warning: mail.retep.org.uk: nobody set sender to peter@retep.org.uk using -f To: Barry Lind Subject: Re: Re: [INTERFACES] Trouble with JDBC2 ResultSet.getDate() Message-ID: <985165919.3ab8705f5ccb9@webmail.retep.org.uk> Date: Wed, 21 Mar 2001 04:11:59 -0500 (EST) From: Peter T Mount Cc: Juhan-Peep Ernits , pgsql-jdbc@postgresql.org References: <3AB799ED.7010706@xythos.com> In-Reply-To: <3AB799ED.7010706@xythos.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.3 X-Archive-Number: 200103/111 X-Sequence-Number: 327 Quoting Barry Lind : > Actually it was the changes in version 1.21 on 2/13 that broke this. > The cvs log for that change includes the following comment: > - Removed need for SimpleDateFormat in ResultSet.getDate() improving > performance. > > My guess is the the code as written would work correctly for a 'date' > column, but doesn't work for a 'timestamp' column. Is there a reason > you are not using getTimestamp() to get the value of the timestamp > column? One of the first things I'm doing once 7.1 is out is add some sanity checking so that the get/set methods on Date, Timestamp, integer, double etc so that getDate() on a Timestamp would work, but also getTimestamp() on a Date column. However, this isn't going to be that easy, and (when I thought of this) 7.1 was already in beta - and this being new functionality couldn't be put in ;-) Peter -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/