Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsEQL / JPQL Operator -datepart- Usage
https://www.eclipse.org/forums/index.php/mv/msg/441248/989728/#msg_989728
I would like to ask about how to use DatePart with OPERATOR which comes with EclipseLink 2.4?
I specifically need dayofyear property. I have searched through documentations but could not find any detailed explanation.
Thanks for your help.]]>Volkan Demircan2012-12-07T12:59:53-00:00Re: EQL / JPQL Operator -datepart- Usage
https://www.eclipse.org/forums/index.php/mv/msg/441248/990298/#msg_990298
EXTRACT(DAYOFYEAR, e.startDate)
For OPERATOR use,
OPERATOR('DatePart', e.startDate, 'DAYOFYEAR')
You could also use SQL('DATEPART(DAYOFYEAR, ?)', e.startDate)