• Post Reply Bookmark Topic Watch Topic
  • New Topic

JPA, Hibernate, Error with convert()

Chris Boldon
Ranch Hand
Posts: 190
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My database has a table that includes date, which I use as a timestamp, giving me nanosecond precision. However, there is a place in my application where I want to group and select rows by Date only, disregarding time.

Perhaps my query is wrong, but this is what I'm calling:

I'm trying to get the number of records for each day.

Hibernate is throwing the following error:

Here is the full method in my DAO:

Any suggestions? Thank you for your time.
Whatever. Here's a tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!