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