Hi,

I am using hibernate with MySQL.

I have written query in MySQL which will fetch records of last 30 days. For that i have written query using DATE_SUB() function of MySQL.

But, its not working in hibernate's query. So, how i can implement DATE_SUB() function in hibernate ?

Thanks.

Hi,

could you be more specific about your usecase? Are you trying to execute a native query or are you trying to use HQL. In the former case you should be able to use database specific functions in the latter case not.

Maybe you could post the code you are trying to execute, together with your configuration files and stacktraces (if any) when executing the code.

--Hardy

Thanks for reply.
I am using HQL.
I have implemented below code :

String searchQuery = "..........
and date_sub_interval(curdate(), 28, DAY ) < b_date and
........";

(where b_date is table filed).

class Dialect extends MySQLInnoDBDialect {

public Dialect() {
super();
registerFunction("date_sub_interval", new SQLFunctionTemplate(
Hibernate.DATE, "date_sub(?1, INTERVAL ?2 ?3)"));
}

}

In above code i am getting error. I am not sure whether above code is correct or not.

Error says:
'DAY' field not found.

I haven't done any other configurations. I have implemented hibernate code using EntityManager and annotations based api.

Hi,

what data type is 'DAY' in your query. wouldn't you just pass it as string? Maybe you have more luck asking this question on the main Hibernate forum.

--Hardy