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 throwing:org.hibernate.exception.SQLGrammarException:could not execute query.
The problem is that mysql converts dates to numerics when you add or subtract. For example, current_date = 2007-04-20, but (current_date + 0) = 20070420. A solution (hack) for this is to do the following: