topic Timestamp format in CMIS query in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/timestamp-format-in-cmis-query/m-p/52504#M19795 <HTML><HEAD></HEAD><BODY><P>Please help with my question on the Timestamp equal to comparison using CMIS query.</P><P></P><P>The clockDate is an aspect/property for a document.</P><P>We see the value of this clockDate for a document in Node Browser as:<BR />13 Oct 2017 10:26:58 GMT-0400 (EDT)</P><P>We see the value of this clockDate for a document in in document library as:<BR />Fri 13 Oct 2017 10:26:58</P><P><BR />We have a CMIS query that we execute in the Node Browser as:</P><P>Select * from cmis:document as d JOIN mystuff:clockableAspect as CA on d.cmis<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId = CA.cmis<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId where CA.mystuff:clockedDateTime = TIMESTAMP 'valueToCompare'</P><P></P><P>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'</P><P></P><P>My question is:</P><P>What value/format should we use for the variable valueToCompare so that we can find the exact match?</P></BODY></HTML> Tue, 23 Jan 2018 16:23:14 GMT raghav 2018-01-23T16:23:14Z Timestamp format in CMIS query https://connect.hyland.com/t5/alfresco-forum/timestamp-format-in-cmis-query/m-p/52504#M19795 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 docume Tue, 23 Jan 2018 16:23:14 GMT https://connect.hyland.com/t5/alfresco-forum/timestamp-format-in-cmis-query/m-p/52504#M19795 raghav 2018-01-23T16:23:14Z Re: Timestamp format in CMIS query https://connect.hyland.com/t5/alfresco-forum/timestamp-format-in-cmis-query/m-p/52505#M19796 <HTML><HEAD></HEAD><BODY><P>Can you check the following thread?</P><P><A _jive_internal="true" class="link-titled" href="https://community.alfresco.com/thread/205607-cmis-query-with-a-date#comment-735076" title="https://community.alfresco.com/thread/205607-cmis-query-with-a-date#comment-735076" rel="nofollow noopener noreferrer">https://community.alfresco.com/thread/205607-cmis-query-with-a-date#comment-735076</A>&nbsp;</P></BODY></HTML> Tue, 23 Jan 2018 19:29:31 GMT https://connect.hyland.com/t5/alfresco-forum/timestamp-format-in-cmis-query/m-p/52505#M19796 douglascrp 2018-01-23T19:29:31Z