|Re: JPQL query date/datetime problem [message #667915 is a reply to message #667490]
||Mon, 02 May 2011 14:38
| James Sutherland
Registered: July 2009
Location: Ottawa, Canada
The JPQL spec does not provide any date conversion functions, but EclipseLink does provide a FUNC() JPQL function that allows usage of database function calls. The database function you use would be specific to your database, such as DATEPART().|
EclipseLink Expressions also define several date functions not currently supported in JPQL.
You could also query that the date-time is between two Timestamp from 0 to midnight, this should be the same as checking the date only.
James : Wiki : Book : Blog : Twitter
Powered by FUDForum
. Page generated in 0.01487 seconds