• 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic