jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel Reutegger <marcel.reuteg...@gmx.net>
Subject Re: SQL query with datetime values
Date Mon, 04 Dec 2006 11:07:21 GMT
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

Mime
View raw message