jackrabbit-users mailing list archives

Lei Zhou wrote:
> 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')

xs:dateTime() is a XPath specific function and cannot be used in SQL. Jackrabbit 
uses the SQL 92 standard:

SELECT * FROM my:nodeType
     WHERE my:dateProp = TIMESTAMP "2006-11-22T00:00:00.000-05:00"

regards
  marcel