[OASIS Issue Tracker] Commented: (CMIS-330) What is the production(BNF) for a list of DateTimes?

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/CMIS-330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13057#action_13057 ] 

Ryan McVeigh commented on CMIS-330:
-----------------------------------

Probably just confusion on my part.  If the spec is using standard SQL, then the issue should be closed.

> What is the production (BNF) for a list of DateTimes?
> -----------------------------------------------------
>
>                 Key: CMIS-330
>                 URL: http://tools.oasis-open.org/issues/browse/CMIS-330
>             Project: OASIS Content Management Interoperability Services (CMIS) TC
>          Issue Type: Bug
>          Components: Domain Model
>    Affects Versions: Draft 0.62
>            Reporter: Ryan McVeigh
>            Assignee: Ethan Gur-esh
>
> The way 0.62b is written, the current BNF for a timestamp in the IN portion of a queryl statement would look like:
>       SELECT * FROM foo WHERE theDate IN (TIMESTAMP "19951231T235959Z", TIMESTAMP "20040123T235959Z", TIMESTAMP "19051119T235959Z" )
> Since all the elements within the IN list must be timestamps and since CMIS has invented the TIMESTAMP thing, I propose we change the format to:
>       SELECT * FROM foo WHERE theDate IN TIMESTAMP ("19951231T235959Z", "20040123T235959Z", "19051119T235959Z" )
>      

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