jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lei Zhou <L...@pointalliance.com>
Subject SQL query with datetime values
Date Fri, 01 Dec 2006 21:55:46 GMT
Hi, 

Could anyone advise what is the correct format to write the following SQL 
queries that includes datetime comparisons?

select * from my:nodeType 
where my:dateProp = xs:dateTime('2006-11-22T00:00:00.000-05:00')


select * from my:nodeType 
where 
   my:dateProp1 > xs:dateTime('2006-11-22T00:00:00.000-05:00') 
and 
   my:dateProp2 < xs:dateTime('2006-11-25T00:00:00.000-05:00')


The XPath query works fine. Just wonder if there is any equivalent in Sql.

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