Eclipse Community Forums: EclipseLink » TIMESTAMP calculations

Help

Home

Home » Eclipse Projects » EclipseLink » TIMESTAMP calculations

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

TIMESTAMP calculations [message #380560]

Fri, 29 August 2008 10:10

Markus KARG
Messages: 44
Registered: July 2009

Member

I noticed that in JPA 1.0 (TopLink) it is possible to do "SELECT x FROM X x
WHERE x.y BETWEEN CURRENT_TIMESTAMP-1 AND CURRENT_TIMESTAMP" what
effectively returns all X instances from now to
one-day-ago-at-the-same-time. That is great and exactly what I need, but in
fact I didn't find anything in the JPA 1.0 specification that this actually
is a mandatory feature of JPA 1.0 and is not just working by incident on
TopLink.

Can you confirm that this will work on ANY JPA 1.0 compliant providers? Or
is that a TopLink / EclipseLink feature?

Thanks!
Markus

Report message to a moderator

Previous Topic:	Order of mapping resolution
Next Topic:	Table Sequence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 18:38:30 EDT 2013