AnsweredAssumed Answered

date query

Question asked by silenr0c on Feb 24, 2011
Latest reply on Mar 7, 2011 by silenr0c
hi i am trying to do date query but not succeed
even trying to post this new topic in several days but no success to post anything, what's wrong with it

Fail
SELECT * FROM cmis:document WHERE cmis:creationDate > TIMESTAMP '2010-06-01T00:00:00.000+00:00'
Success
SELECT * FROM cmis:document WHERE cmis:creationDate = TIMESTAMP '2010-09-01T01:00:00.000+00:00'

it seems that i can't use < (less than) and > (greater than) for date comparison

Outcomes