jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcel Reutegger (JIRA)" <j...@apache.org>
Subject [jira] Created: (JCR-660) SQL Parser fails with SQL 92 timestamp format
Date Mon, 04 Dec 2006 11:00:20 GMT
SQL Parser fails with SQL 92 timestamp format
---------------------------------------------

                 Key: JCR-660
                 URL: http://issues.apache.org/jira/browse/JCR-660
             Project: Jackrabbit
          Issue Type: Improvement
    Affects Versions: 0.9, 1.0, 1.0.1, 1.1, 1.1.1
            Reporter: Marcel Reutegger
         Assigned To: Marcel Reutegger
            Priority: Minor
             Fix For: 1.2


The SQL query parser fails with an exception if the SQL 92 timestamp format is used.

E.g:
... WHERE my:date > TIMESTAMP '1976-01-01 00:00:00.000+01:00'

does not work, but the following will succeed using ISO8601:

... WHERE my:date > TIMESTAMP '1976-01-01T00:00:00.000+01:00'

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message