Hibernate version:3.2

Hey all

I have a Movie class mapped with a "created" Timestamp property. How can I search for movies where the Timestamp starts with a certain date? I am receiving dates in the form of yyyy-mm-dd.

This is my code so far, which won't return any results at all.



Thanks!

like this:



this code fragment will select entities with "created" property greater than (gt) today (new Date())

See _Restrictions_ class for similar methods (le, between, ...)

But I want it to be an equal date, not greater than or less than a certain date. The problem is that the datatype i am querying for is a Timestamp while I want all Timestamps within the range of a day (yyyy-mm-dd). The Restrictions.eq obviously won't work since there is no perfect match - can I somehow trim the created column before I query for it?

what precision you want? a day as the smallest time unit?

1. you have a representation of that Date in Java as a java.util.Date i guess? If so you, i do something like:

* i take that Date and create two new Dates -- the beginnig of a day and end of a day. simple if you use the java.util.Calendar

* use Restriction.between or combination of Restrictions.le || Restrictions.gt and make input both of the newly created dates as a interval -- the query generated contains st like: whete ? < dateProperty and dateProperty < ? -- you choose anything that lies between the interval boundaries

2. you may create your column as a date (to store only yyyy-mm-dd value) -- in that case any java.util.Date will be matched only by the fields it has ignoring any "lesser" time units (like hours and minutes). Use st like:



3. JFYI -- the "yyyy-mm-dd" is output of java.sql.Date, look for the db column type definition -- it could be only date and or date and time, you can't recognize it from this string output