Hi all,

I've really got confused with this issue : wich method getXXX () on ResultSet should i use to retrieve data of type "interval" from the database?

I'm using postgresql 7.1 and jboss 2.4.3.

I tried to call all of the getXXX method of a resultset on a "interval"-type field. seven calls succeed (that is no exception is thrown) but none seems to fit my need - Neither getTime, getDate nor getTimestamp works (since an interval is a bit kind of date - i thought those methods would work ...)

So what method to use ????

Please help ..

Thanx in advance
--hermann