CMIS query preparation - TimeZone issue

[nikes]

Hi All,

I am using Apache CXF framework and generated client side stub classes for CMIS.
Alfresco : 3.2r2
Java      : 1.6

I 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("yyyy-MM-dd'T'HH:mm:ss.sssZ");
Date newDate = new Date();
String strDate = formatter.format(newDate);

String query = "SELECT * FROM cmis:document where cmis:creationDate >= ' " + strDate + " ' ";

‍‍‍‍‍‍‍‍

Here value of strDate contains following format,

2010-06-18T17:06:49.049+0530‍

It throws following exception when I execute query method of DiscoveryService

org.alfresco.service.cmr.repository.datatype.TypeConversionException: Failed to convert date 2010-06-18T17:07:36.036+0530 to string
‍‍‍

Kindly suggest in which format to prepare date values in WHERE clause of CMIS query language.

Thanks for any help.
Nikesh

[gclaussn]

Hi Nikes

use this pattern to query documents, which greater or lesser creation date.
"SELECT * FROM cmis:document WHERE cmis:creationDate > TIMESTAMP '2010-06-01T00:00:00.000+00:00'"

best regards, gclaussn