[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,
I miss the old days when I would think up a sinister scheme for world domination and you would show a little emotional support. So just look at this tiny ad:
Why should you try IntelliJ IDEA ?
https://coderanch.com/wiki/696337/IntelliJ-IDEA


This thread has been viewed 2788 times.

All times above are in ranch (not your local) time.
The current ranch time is
Aug 20, 2018 22:59:17.