Register / Login
Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
this forum made possible by our volunteer staff, including ...
Stephan van Hulst
Object Relational Mapping
substract n minutes to sysdate (Oracle, HQL hibernate 2)
posted 8 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.
rocket mass heater
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