pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter T Mount <peter@retep.org.uk>
To: Barry Lind <barry@xythos.com>
Cc: Juhan-Peep Ernits <juhan@cc.ioc.ee>
Cc: pgsql-jdbc@postgresql.org
Subject: Re: Re: [INTERFACES] Trouble with JDBC2 ResultSet.getDate()
Date: Wed, 21 Mar 2001 04:11:59 -0500 (EST)
Message-ID: <985165919.3ab8705f5ccb9@webmail.retep.org.uk> (raw)
In-Reply-To: <3AB799ED.7010706@xythos.com>
References: <Pine.GSO.4.21.0103201120540.27805-100000@suhkur.cc.ioc.ee>
	<3AB799ED.7010706@xythos.com>

Quoting Barry Lind <barry@xythos.com>:

> 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/



view thread (13+ messages)  latest in thread

Message-ID: <985165919.3ab8705f5ccb9@webmail.retep.org.uk>
Permalink:  ../985165919.3ab8705f5ccb9@webmail.retep.org.uk/
Also on:    postgresql.org/message-id/985165919.3ab8705f5ccb9@webmail.retep.org.uk

 · 

reply

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: peter@retep.org.uk, barry@xythos.com, juhan@cc.ioc.ee, pgsql-jdbc@postgresql.org
  Subject: Re: Re: [INTERFACES] Trouble with JDBC2 ResultSet.getDate()
  In-Reply-To: <985165919.3ab8705f5ccb9@webmail.retep.org.uk>

* 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