Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0.5

Name and version of the database you are using: SQL Server 7.0 / 2000

Hi all,

I have the following SQL statement :

SELECT * FROM Orders WHERE MONTH(OrderDate) = 1

I need help on using Criteria & Restrictions to produce the same results as above query.

Thanks in advance.


Setya

I have a somewhat similar question, and can't seem to find an answer on these forums. We have a table with a timestamp column, but would like to perform a query ignore the time part of that column, just the date. In SQL, something like:

select * from orders where TRUNC(order_date) <= TO_DATE('07/16/2005', 'mm/dd/yyyy')

to get all orders from today, regardless of time. How can this be accomplished using the criteria API?

Thanks.

so is this not possible?

I do this by adding one day to the date first, and setting the time portion to zero. Something like this (in your case):