Eclipse Community Forums: EclipseLink » EQL / JPQL Operator -datepart- Usage

Help

Home

Home » Eclipse Projects » EclipseLink » EQL / JPQL Operator -datepart- Usage

Show: Today's Messages :: Show Polls :: Message Navigator

EQL / JPQL Operator -datepart- Usage [message #989728]

Fri, 07 December 2012 12:59

Volkan Demircan

Messages: 1
Registered: December 2012

Junior Member

Hi,

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.

[Updated on: Fri, 07 December 2012 14:13]

Report message to a moderator

Re: EQL / JPQL Operator -datepart- Usage [message #990298 is a reply to message #989728]

Tue, 11 December 2012 18:22

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

You may also be able to use EXTRACT,

EXTRACT(DAYOFYEAR, e.startDate)

For OPERATOR use,

OPERATOR('DatePart', e.startDate, 'DAYOFYEAR')

You could also use SQL('DATEPART(DAYOFYEAR, ?)', e.startDate)

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	query a subpart of complex graph and get a smallest object
Next Topic:	Objects still exists after commit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 11:34:51 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter