jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Mueller" <thomas.tom.muel...@gmail.com>
Subject Re: SQL query with datetime values
Date Mon, 04 Dec 2006 09:51:39 GMT
> 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

Mime
View raw message