Register / Login
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
Object Relational Mapping
substract n minutes to sysdate (Oracle, HQL hibernate 2)
posted 6 years ago
Here is HQL I use for adding days:
"select * from Person pers where (pers.birth> trunc(sysdate - :daysoffset))" - Persons with birth date after "daysoffset" days from now.
but the birth field is full date with minutes and seconds. I want: Persons with birth date after "daysoffset" MINUTES from now.
Boost this thread!
writing a HQL query with date calculation
howto: Date arithmatic ?
Java date to MySQL date conversion
How to minus 45 days from from the current sysdate