AnsweredAssumed Answered

CMIS and date time search

Question asked by romschn on Dec 16, 2011
Latest reply on Dec 16, 2011 by mrogers
Hi,

I have read on wiki(http://wiki.alfresco.com/wiki/CMIS_Query_Language - Section-dateTime) and also observed that Date collation ignores time by default.

I have two records in my repository for which the modified date timestamp is different.
Content-1 modification date - 2011-12-16T14:17:44.815+05:30
Content-2 modification date - 2011-12-16T14:25:48.108+05:30

My below CMIS query :
SELECT * FROM cmis:document WHERE cmis:lastModificationDate > TIMESTAMP '2011-12-15T14:20:00.000-00:00' 
is always returning me the above 2 records. It is not considering the timestamp for search and doing search based on date only. As per the timestamp in the query I should have got Content-2 as a result only.

I want to search based on timestamp. Could anyone please help me on this.

Thanks,

Outcomes