Win a copy of Machine Learning Systems: Designs that scale this week in the Scala forum
or Xamarin in Action: Creating native cross-platform mobile apps in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

substract n minutes to sysdate (Oracle, HQL hibernate 2)  RSS feed

 
Ranch Hand
Posts: 239
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
 
All of life is a contant education - Eleanor Roosevelt. Tiny ad:
free 1 hour java lesson
https://coderanch.com/t/695988/free-hour-java-lesson
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!