Jackrabbit uses the SQL 92 standard:
SELECT * FROM my:nodeType
WHERE my:dateProp = TIMESTAMP "2006-11-22T00:00:00.000-05:00"
Actually, the 'T' between date and time is ISO 8601, and not SQL 92. The " around the timestamp would be ' in standard SQL. Sorry for beeing a SQL grammar nazi... Thomas
