AnsweredAssumed Answered

Timestamp format in CMIS query

Question asked by raghav on Jan 23, 2018
Latest reply on Jan 23, 2018 by douglascrp

Please help with my question on the Timestamp equal to comparison using CMIS query.

 

The clockDate is an aspect/property for a document.

We see the value of this clockDate for a document in Node Browser as:
13 Oct 2017 10:26:58 GMT-0400 (EDT)

We see the value of this clockDate for a document in in document library as:
Fri 13 Oct 2017 10:26:58


We have a CMIS query that we execute in the Node Browser as:

Select * from cmis:document as d JOIN mystuff:clockableAspect as CA on d.cmis:objectId = CA.cmis:objectId where CA.mystuff:clockedDateTime = TIMESTAMP 'valueToCompare'

 

For the 'valueToCompare', if we hard-code as '13 Oct 2017 10:26:58 GMT-0400 (EDT)', or as 'Fri 13 Oct 2017 10:26:58', we do not get any result back, and it says 'invalid datetime literal'

 

My question is:

What value/format should we use for the variable valueToCompare so that we can find the exact match?

Outcomes