date query

[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

[silenr0c]

FYI: I try in 2 different versions
CMIS repository info ( I try in 2 different version in separate server)
Version Supported   1.0
Specification Title   CMIS Version 1.0 Committee Draft 07
Repository Id   01fc63fe-ce87-46a6-9d61-01368f11a5f8
Repository Name   Main Repository
Repository Description   [none]
Vendor Name   Alfresco
Product Name   Alfresco Repository (Community)
Product Version   3.3.0 (2765)

Version Supported   1.0
Specification Title   CMIS Version 1.0 OASIS Standard
Repository Id   01fc63fe-ce87-46a6-9d61-01368f11a5f8
Repository Name   Main Repository
Repository Description   [none]
Vendor Name   Alfresco
Product Name   Alfresco Repository (Community)
Product Version   3.4.0 (c 3335)

[andy]

Hi

There have been some bug fixes to datetime date ranges (used by the first query).
This is not yet in any community version. It will be in the next one after 3.4.

Andy

[andy]

Hi

I have tried your example on 3.4.1 E and it works as expected.

Andy

[silenr0c]

Hi Andy,

Thanks for your reply
At least I know it's not setting issue whatsoever in my server.

Then there's nothing I can do other than waiting the bug fixed in new community release later on.

Thanks again.
silenr0c