topic CMIS query preparation - TimeZone issue in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-query-preparation-timezone-issue/m-p/212609#M165739 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>I am using Apache CXF framework and generated client side stub classes for CMIS.</SPAN><BR /><SPAN>Alfresco : 3.2r2</SPAN><BR /><SPAN>Java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 1.6</SPAN><BR /><BR /><SPAN>I am not able to perform search using creationdate/modifieddate for documents.</SPAN><BR /><BR /><SPAN>I am getting date in following format in java code,</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.sssZ");<BR />Date newDate = new Date();<BR />String strDate = formatter.format(newDate);<BR /><BR />String query = "SELECT * FROM cmis:document where cmis:creationDate &gt;= ' " + strDate + " ' ";<BR /><BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Here value of strDate contains following format,</SPAN><BR /><PRE class="language-none line-numbers"><CODE>2010-06-18T17:06:49.049+0530<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>It throws following exception when I execute query method of DiscoveryService</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />org.alfresco.service.cmr.repository.datatype.TypeConversionException: Failed to convert date 2010-06-18T17:07:36.036+0530 to string<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Kindly suggest in which format to prepare date values in </SPAN><STRONG>WHERE</STRONG><SPAN> clause of CMIS query language.</SPAN><BR /><BR /><SPAN>Thanks for any help.</SPAN><BR /><SPAN>Nikesh</SPAN></BODY></HTML> Fri, 18 Jun 2010 11:39:29 GMT nikes 2010-06-18T11:39:29Z 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