Hi All,

Does anybody know how Hibernate 3 handles interval data type that is returned as part of HQL query.
It seems that it tries to get it as Timestamp. Is it correct?

Thanks,
Gil

Hibernate "tries to get it" based on however you have defined the corresponding property in terms of its type.

This is clear, but what happens in HQL query with custom SELECT clause, for example

select o.date1 - o.date2 from mypackage.MyObject as o

where date1 and date2 are properties of MyObject of type Timestamp.
The database's type which is returned is an INTERVAL.

What is Hibernate expected to do in this situation (does it try to convert it to timestamp)?

Thanks,
Gil