Sleep Date Literals

Question

I wonder how to use date literals in the Hibernate query language. In my JPA project, I did the following (as an Eclipselink 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 a provider for my JPA project.

Answer 1

The help documentation says:

The expressions used in the where clause include the following:
[...]

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