Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate: Getting time/date in simple sql queries

 
Jacek D.
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

My problem is quite easy. I need to get a database date/time to using query like this: SELECT now() or SELECT CURRENT_TIMESTAMP.

HQL treats now() or CURRENT_TIMESTAMPS as aliases (I don't know how to tell him to pass these to sql). That's why I tried using createSQLQuery function, however it requires specyfing return class. What class should I use? I was trying different combinations, for example:




however it gives following exception:



This seems strange to me as I don't have to map library classes.

I suppose the solution is straightforward and it's just my incompetence that causes problems

Help!
jacek
[ November 25, 2004: Message edited by: Jacek D. ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic