Bookmark Topic Watch Topic
  • New Topic

hql query to get records of the week  RSS feed

krish bhadragiri
Posts: 13
  • Mark post as helpful
  • send pies
  • Report post to moderator
i want to retrieve records of the week (i.e records since last 7days).i wrote
"from WorkDetails as work_details where work_details.dated<=current_date and dated>=currrent_date-7 and work_details.employee_id="+employee_column_id"

but its throwingrg.hibernate.exception.SQLGrammarException:could not execute query.
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!