Hibernate Community • View topic - Oracle and date functions

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Oracle and date functions

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Saloucious

Post subject: Oracle and date functions

Posted: Fri Aug 26, 2005 8:37 am

Newbie

Joined: Wed Aug 10, 2005 8:07 am
Posts: 14

Hi,
is it possible to use function like interval or current_date with Hibernate 3 :
Something like that :

Code:

Query q = session.createQuery(
                     "from Bank bk " +
                     "where b.balanceDate > current_date - interval :time" );
      q.setString("time","25 day");

is HQL can parse this ?
Anf if not how can i have the same result

Thanks

Top

alesj

Post subject:

Posted: Fri Aug 26, 2005 8:51 am

Expert

Joined: Sat Oct 25, 2003 8:49 am
Posts: 490
Location: Vrhnika, Slovenia

Look at interface SQLFunction.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum