OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

odata message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Commented: (ODATA-112) DateTime[Offset]: allow 24:00[:00] in time part

    [ http://tools.oasis-open.org/issues/browse/ODATA-112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=31373#action_31373 ] 

Andrew Eisenberg commented on ODATA-112:

IBM's DB2 supports datetime values with "24:00:00". A quick web search leads me to believe that it is supported in Ingres as well.

I'll summarize the comments in this thread.

24:00:00 is supported:
ISO 8601
XML Schema
SQL Server Integration Services

24:00:00 is not supported:
MySQL and many other DBMSs
RFC1123 and RFC822 (restricted via comment)

> DateTime[Offset]: allow 24:00[:00] in time part
> -----------------------------------------------
>                 Key: ODATA-112
>                 URL: http://tools.oasis-open.org/issues/browse/ODATA-112
>             Project: OASIS Open Data Protocol (OData) TC
>          Issue Type: Bug
>          Components: OData CSDL v1.0
>    Affects Versions: WD01
>         Environment: [Proposed]
>            Reporter: Ralf Handl
>            Assignee: Ralf Handl
>            Priority: Minor
>             Fix For: WD01
> http://www.w3.org/TR/xmlschema-2/#dateTime allows 24 in the hour part of a dateTime if the minutes and seconds represented are zero, and the dateTime value so represented is the first instant of the following day.

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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]