Hibernate query for select records based on the date?

Question

I'm using hibernate for the data access layer,
so i have to write HQL query for the following SQL query.

select * from MyTable where my_date >= '16-SEP-2012'

It is working fine.. For this i have written HQL query as follows,

From MyTable as NB where NB.my_date >=date

It is throwing an error..

From MyTable as NB where NB.my_date >=Mon Mar 07 00:00:00 IST 1 org.hibernate.hql.ast.QuerySyntaxException: unexpected token: Mar

How to write HQL query for this.. Any Idea?

Rasmus Franke · Accepted Answer · 2012-09-21 06:19:34Z

0

Try :date, since your current code is a syntax error. If it still doesn't work, try using a yyyy-MM-dd format - it might be a locale issue. Also be sure to set the parameter properly, you Did not include that part of your code.

answered Sep 21, 2012 at 6:19

Rasmus Franke

4,5348 gold badges49 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mr.Chowdary Over a year ago

date of HQL is dynamic. So i just directly used it..What would be the syntax to execute it successfully?

Rasmus Franke Over a year ago

Oh you concate strings? Then your date needs to be insides single quotes. I strongly recommend using proper parameters instead. Criteria api is a good alternative aswell for dynamic queries.

Rasmus Franke Over a year ago

Be ware that constructing queries like that can potentially leave you open to sql injektion. Less so with jpa but still a very bad practice.

Collectives™ on Stack Overflow

Hibernate query for select records based on the date?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related