How to execute SQL querie and have hibernate return a Date

acoronasz · **Joined:** Mon Feb 27, 2006 6:47 pm **Posts:** 8

I have a SQL query I need to execute and I'd like to use hibernate's createSQLQuery function to execute the forllowing "SELECT Tz.Plant_SysDate('01') FROM DUAL" this returns the system date and would like to get back a java Date. Can I do this and how?

Thanks

max · **Posted:** Mon Mar 13, 2006 3:54 am

session.createSQLQuery("SELECT Tz.Plant_SysDate('01') as VALUE FROM DUAL").addScalar("VALUE", Hibernate.DATE)