topic Re: CMIS query preparation - TimeZone issue in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-query-preparation-timezone-issue/m-p/212610#M165740 <HTML><HEAD></HEAD><BODY><SPAN>Hi Nikes</SPAN><BR /><BR /><SPAN>use this pattern to query documents, which greater or lesser creation date.</SPAN><BR /><SPAN>"SELECT * FROM cmis:document WHERE cmis:creationDate &gt; TIMESTAMP '2010-06-01T00:00:00.000+00:00'"</SPAN><BR /><BR /><SPAN>best regards, gclaussn</SPAN></BODY></HTML> Fri, 18 Jun 2010 13:27:40 GMT gclaussn 2010-06-18T13:27:40Z CMIS query preparation - TimeZone issue https://connect.hyland.com/t5/alfresco-archive/cmis-query-preparation-timezone-issue/m-p/212609#M165739 Hi All,I am using Apache CXF framework and generated client side stub classes for CMIS.Alfresco : 3.2r2Java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 1.6I am not able to perform search using creationdate/modifieddate for documents.I am getting date in following format in java code,SimpleDateFormat formatter = new SimpleDateFormat("yy Fri, 18 Jun 2010 11:39:29 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-preparation-timezone-issue/m-p/212609#M165739 nikes 2010-06-18T11:39:29Z Re: CMIS query preparation - TimeZone issue https://connect.hyland.com/t5/alfresco-archive/cmis-query-preparation-timezone-issue/m-p/212610#M165740 <HTML><HEAD></HEAD><BODY><SPAN>Hi Nikes</SPAN><BR /><BR /><SPAN>use this pattern to query documents, which greater or lesser creation date.</SPAN><BR /><SPAN>"SELECT * FROM cmis:document WHERE cmis:creationDate &gt; TIMESTAMP '2010-06-01T00:00:00.000+00:00'"</SPAN><BR /><BR /><SPAN>best regards, gclaussn</SPAN></BODY></HTML> Fri, 18 Jun 2010 13:27:40 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-preparation-timezone-issue/m-p/212610#M165740 gclaussn 2010-06-18T13:27:40Z