[Logo]
Forums Register Login
substract n minutes to sysdate (Oracle, HQL hibernate 2)
Hi,
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.

Thanks,

This thread has been viewed 2919 times.

All times above are in ranch (not your local) time.
The current ranch time is
Nov 19, 2018 04:51:23.