Do you think we could and should support the ANSI SQL style periods and temporal operators (overlaps, during, before, after, etc.) in a portable way?
from Contract c where [c.effectiveStartDate, c.effectiveEndDate] overlaps (:start, :end]
(Unfortunately, Java has no Period or Interval class that we could create a standard Hibernate Type for.)
You might find http://joda-time.sourceforge.net/ usefull for this. It provides Period and Interval.
--- Mario
------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel