Bookmark Topic Watch Topic
  • New Topic

hql query to get records of the week

 
krish bhadragiri
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Report post to moderator
hi,
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