jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JOSE FELIX HERNANDEZ BARRIO <jose.hernan...@isthari.com>
Subject Dates in search
Date Wed, 17 Mar 2010 12:34:35 GMT
Hi,


I'm trying to search between two dates:
select * from temp where( date>='2010-02-01' and date<='2010-02-11')
but the result is wrong

i've also tryed the examples:
select * from test where a=cast('+2001-01-01T01:02:03.000Z' as date)
i obtained a invalid query exception



any tip ??

-- 
Jose Hernandez
675599600
Isthari
http://www.isthari.com

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message