Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate: Getting time/date in simple sql queries

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

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

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