persistence@glassfish.java.net

Re: how to compare 2 dates in a JPA QL query

From: Quintin Beukes <quintin_at_last.za.net>
Date: Thu, 14 Aug 2008 08:52:56 +0200

Can you give an example of the ==, >=, etc. that doesn't work.

Give the JPA-QL, the field definitions in your entity, and the entity
names (these include any annotations on the fields).
Then the most important, give the error message.

Q

On Wed, Aug 13, 2008 at 12:59 PM, chflb <labidi.chifa_at_gmail.com> wrote:
>
> thank you for your reply,
> but none of =<,<,>,=>, =, current_date, works with me,
> i have this message::"A persistence error occurred."
> (but the query works without this comparison)
> in fact, the origin of my idea to use to_char, is that i like to select the
> dates of the same month (by putting in the 'to_char' function :'MM/YYYY'
> instead of 'MM/DD/YYYY' )
> if it is not possible with to_char so can i do this?
> thany you
> --
> View this message in context: http://www.nabble.com/how-to-compare-2-dates-in-a-JPA-QL-query-tp18959789p18960901.html
> Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.
>
>



-- 
Quintin Beukes