CODEWITHSUNDEEP
hibernatejpahqleclipselinkjpql
siva636
siva636

Reputation: 16451

Date literals in Hibernate

I wonder how to use date literals in Hibernate query language. I did as follows in my JPA project (as Eclipselink the provider) and it works.

SELECT m FROM Me m WHERE m.dob <= {d '1984-10-06'}

But this does not work when I change Hibernate (V 3.6.7) as the provider for my JPA project.

Upvotes: 9

Views: 3061

Answers (1)

JB Nizet
JB Nizet

Reputation: 692231

The reference documentation says:

Expressions used in the where clause include the following:
[...]

  • SQL literals 'foo', 69, 6.66E+2, '1970-01-01 10:00:01.0'

Upvotes: 4

Related Questions