[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
DB2
PostgreSQL
Ingres
SQL Server Integration Services
24:00:00 is not supported:
MySQL and many other DBMSs
ANSI/ISO SQL
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]