Thomas Mueller wrote:
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.
you are right.
and there was actually a bug in the parser that prevented the use of a space
instead of the 'T', even though the initial intention was that one could use
either. See: http://issues.apache.org/jira/browse/JCR-660
regards
marcel
