substract n minutes to sysdate (Oracle, HQL hibernate 2)
, Ranch Hand
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.
There's a way to do it better - find it. -Edison. A better tiny ad:
ScroogeXHTML 7.1 - RTF to HTML5 / XHTML converter
This thread has been viewed 2509 times.
All times above are in ranch (not your local) time.
The current ranch time is
Feb 21, 2018 04:19:31.