current date in a portable way

ta · **Joined:** Wed Jun 30, 2004 12:37 pm **Posts:** 9

Hi,
Is it possible to write a HQL query that compares a field to the current date in a portable way ? For instance, the current date in Oracle is SYSDATE but it's NOW() in HSQLDB. This forces me to change the query when I change the data base which is annoying in my case.
Thanks in advance.
Hibernate version:2.1.6

anthony · **Posted:** Sun Aug 22, 2004 5:34 pm

you can do it in java ? more portable than the db...

gavin · **Posted:** Sun Aug 22, 2004 7:52 pm

hibernate.query.substitutions

By the way, most db now support the ANSI variation: current_date

However, I think Oracle9's current_date and current_timestamp are something "special", and have slightly diff semantics to the ANSI functions (not 100% on this though)

https://cwisdb.cc.kuleuven.ac.be/ora10d ... ons032.htm

bertrand · **Posted:** Mon Aug 23, 2004 5:56 pm

anthony wrote:

you can do it in java ? more portable than the db...

And safer in some environment where it is the 'application' time that matters and not the 'database' time...

Also very usefull to do it in Java when it comes to test the application - especialy features whose result depends on the current time ;)