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
Did you tried to use getObject() and the investigate what type of Object it is (INSTANCE.class.getName()) ?
Andy