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. ]
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Hibernate: Getting time/date in simple sql queries