jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Müller <thomas.muel...@day.com>
Subject Re: Dates in search
Date Thu, 18 Mar 2010 10:58:05 GMT
Hi,

I'm sorry, JCR 2.0 doesn't support "date without time".

>select * from temp where( date >= TIMESTAMP '2010-02-01T00:00:00.000Z'
> and date >= TIMESTAMP '2010-02-11T00:00:00.000Z')

I believe this syntax is not supported in JCR 2.0. See also
http://www.h2database.com/jcr/grammar.html

The supported syntax is: select * from test where
a=cast('+2001-01-01T01:02:03.000Z' as date)

Regards,
Thomas

Mime
View raw message