Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using SQL date() function in HQL Select

 
Asad Imtiaz
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello guys

I am running into a problem using Hibernate, basically I need to translate the follow SQL (to HQL)



to HQL (which i am doing as follows)




Now this gives me the following exception



but if I run the same HQL without the sql date() function in the select clause the HQL gives no exception but thats not the result I want.


Now the reason I am using the date() function is that my date column is database table is of type "timestamp" which means the format is like "dd/mm/yyyy hh:mm:ss".



Now what I have to do in my query is to group by the date part i.e. (dd/mm/yyyy) and the status.

Any idea how can i achieve this using HQL ?




What I am using is

-Hibernate 3.2.2ga
-EnterpriseDB
-JDK 1.5




Thank you.










 
Asad Imtiaz
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Got it working. Used instead of date().


Problem solved
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic