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.