CODEWITHSUNDEEP
hibernatehql
superfish
superfish

Reputation: 103

HQL date query question

if I am expecting a Date object say for 2011-03-05

and I want to use HQL to pull everything in 2011-03, ignoring the day/05

something like where year(somecolumn) = year(datepassedin) and month(somecolumn) = month(datepassedin)

is it possible to do in HQL?

It seems to be pertty easy to do in SQL, but not in HQL

Upvotes: 0

Views: 2433

Answers (2)

Donald.McLean
Donald.McLean

Reputation: 899

I tried two different versions of this same query and in SQL Server, something like what you have where year(somecolumn) was significantly slower (by almost an order of magnitude) than a bracketing query.

You have to create two dates, one at the beginning of the range, and one at the end. Say that you have a string:

val data = "2011-03-05"

Somewhere create a convenient const for parsing the value:

val dateFormat: SimpleDateFormat = new SimpleDateFormat("yyyy-MM")

And then:

val yearMonthString = data.substring(0, 7)

val fromValue = dateFormat.parse(yearMonthString)
val c: Calendar = Calendar.getInstance(iPutATimeZoneHere)
c.setTime(fromValue)
c.add(Calendar.MONTH, 1)
val toValue = c.getTime

In your query, you'll have where somecolumn >= :fromValue and somecolumn < :toValue.

This code is written in Scala, but it uses standard Java libraries.

Upvotes: 0

Anthony Accioly
Anthony Accioly

Reputation: 22461

Well HQL has year and month expressions and you can feed it date objects just fine. So, just use a Query object as usual, nothing fancy or complicated.

Upvotes: 1

Related Questions