• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
John Landon
Ranch Hand
Posts: 228
  • 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,
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic