How can I write HQL for SYSDATE?

Question

I have a condition that checks the current date - 3.

select * from TABLE_1 SYSDATE-3 >= TABLE_1.created_date

How do I write in the Hibernate query language?

+3

gviswanathan Apr 24 '12 at 21:20

2 answers

For the Oracle SQL dialect, use sysdate(), as in this example:

select e
from Entity e
where (e.endDate is null or (e.endDate > sysdate()))

This is true for orm.xmlor when using<named-query>

For your specific query, "all rows that have not been created in the last three days," use this:

select e from Entity e where to_date(sysdate() - 3) >= e.created_date

+4

egallardo Apr 30 '13 at 23:04

danny.lesnik · Accepted Answer · 2012-04-24T21:37:00+0000

You need to write HQL using your entities.

There are several examples that use sysdate.