[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=12908#action_12908 ] 

Florent Guillaume commented on CMIS-330:
----------------------------------------

CMIS didn't invent TIMESTAMP, it's in SQL-92 and is a recognized data type.

         5.3  <literal>
         ...
         <datetime literal> ::= <date literal> | <time literal> | <timestamp literal>
         ...
         <timestamp literal> ::= TIMESTAMP <timestamp string>
         ...
         <timestamp string> ::= <quote> <date value> <space> <time value> [ <time zone interval> ] <quote>

So I'm -1 on this proposal.


> 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