Register / Login
Win a copy of
Machine Learning Systems: Designs that scale
this week in the
Xamarin in Action: Creating native cross-platform mobile apps
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 7 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.
All of life is a contant education - Eleanor Roosevelt. Tiny ad:
free 1 hour java lesson
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