question about hql

shankar25 · **Joined:** Thu Jul 06, 2006 6:47 pm **Posts:** 2

Hibernate version:
3.0
Name and version of the database you are using:
DB2

Does hibernate hql has any query to retrieve the "current timestamp" from the database? . I'm trying to retrieve the "current timestamp" from DB2 Database to perform some business.

will appreciate your reply
thanks
Shankar

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Use an SQL query for that.

Code:

<sql-query name="CurrentTimestamp">
  <return-scalar name="curTime" type="datetime"/>
  select CURRENT TIMESTAMP as curTime
</sql-query>

I think that's how you do it on DB2.

shankar25 · **Joined:** Thu Jul 06, 2006 6:47 pm **Posts:** 2

Thanks for your reply.

How could I use "VALUES (CURRENT TIMESTAMP)" which is one of the query that gets DB2 date time,

I tried the following but didn't work,

<sql-query name="CurrentTimestamp">
<return-scalar column="curTime" type="datetime"/>
VALUES(CURRENT TIMESTAMP)
</sql-query>

Also will I need a domain java class for the above ?

Thanks
Shan

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Use "select values (CURRENT TIMESTAMP)". You omitted the select.

No, you don't need a class. The return-scalar element tells hibernate that the result set returns a scalar, not an entity.