Hibernate hql Query local time function to_days () __ function

The Hibernate HQL represents the conversion of a day from a date type. For example:

This HQL statement indicates the time period in which the purchase date is between.

<pre name= "code" class= "java" ><span style= "font-size:18px;" >string hql = "from Assets a where to_days (a.buydate) >=to_days (?) and To_days (a.buydate) <=to_days (?) ";
		
		Session session = Util.getsession ();             Gets the session object that is talking to the database.
		
		query query = session.createquery (HQL);              Create a Query object
		
		query.settimestamp (0, time1);                      Sets a value for the precompiled hql.
		
		Query.settimestamp (1, time2);                         Set for precompiled HQL. return
		
		query.list ();               Returns the query results. </span>