You have to do it with with SQL (see session.createSQLQuery() ). I'd suggest caution though. Using the DB server time is not going to be as portable as getting the time in the
Java app and persisting that. Its usually the application's time which is important too, not the DB server's time. Which is why I think the Hibernate people have not thought it important to include in HQL.