[magnolia-user] JCR : queries on dates

[Oktay, Zarife (CH)]

Hi,

I have a problem with JCR queries on date fields.

I try to make a query on modificationDate and creationDate. I tried the
following queries but neither of them are working : 

select * from mgnl:metaData WHERE modificationDate < '2008-12-07'

select * from mgnl:metaData WHERE modificationDate < '2008-12-07
12:20:46'

select * from mgnl:metaData WHERE modificationDate <
xs:dateTime('2008-12-07T12:20:46.275+01:00')

select * from mgnl:metaData WHERE modificationDate <
dateTime('2008-12-07T12:20:46.275+01:00')

Does anyone know the right format to make queries on date fields ? 
Thanks.

Zarife Cal-Oktay

************************************************************************************
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please notify the system manager 
([EMAIL PROTECTED]) and delete the message with any attached files from your 
system.
The confidentiality and integrity of this message cannot be guaranteed on the 
Internet and the sender does not accept liability for its content.

***********************************************************************************


----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/developer.html
----------------------------------------------------------------