From: <glassfish_at_javadesktop.org>
Date: Thu, 20 Nov 2008 08:24:08 PST

Do you know can I add 3 months to timestamp in query.
something like:
'SELECT f.id FROM Foo f WHERE f.timestamp1 + [i][b]3MONTHS[/b][/i] > f.timestamp2. '
or
'SELECT f.id FROM Foo f WHERE f.timestamp1[i].add(3 months)[/i] > f.timestamp2. '
or somethnig like this
[Message sent by forum member 'du27177' (du27177)]

http://forums.java.net/jive/thread.jspa?messageID=317881