Uploaded image for project: 'OASIS Open Data Protocol (OData) TC'
  1. OASIS Open Data Protocol (OData) TC
  2. ODATA-1123

Allow 24:00:00 for Edm.TimeOfDay (public review comment c201710e00003)

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: V4.01_CSD03, V4.01_CSD02
    • Fix Version/s: None
    • Component/s: CSDL JSON , CSDL XML
    • Labels:
      None
    • Environment:

      [Proposed]

    • Proposal:
      Hide

      Resolve with no action. ISO 8601 has explicitly removed 24:00 for information exchange in order to avoid ambiguity. As most common programming langauges don't support storing this as a distinct value (even those that accept such a value), clients would have problems roundtripping the value.

      Show
      Resolve with no action. ISO 8601 has explicitly removed 24:00 for information exchange in order to avoid ambiguity. As most common programming langauges don't support storing this as a distinct value (even those that accept such a value), clients would have problems roundtripping the value.
    • Resolution:
      Hide

      Closed with no action 2017-10-26.

      Show
      Closed with no action 2017-10-26.

      Description

      Public review comment https://lists.oasis-open.org/archives/odata-comment/201710/msg00003.html

      CSDL 4.01 permits Edm.TimeOfDay values to range from 00:00:00 to 23:59:59.999*.

      However existing systems (e.g. SAP backends) frequently utilize 24:00:00 to indicate end-of-day. Requiring these values to be transmitted (e.g. to clients) as 23:59:59.999* could result in round-trip data loss.

      In fact such SAP systems (for V2/V4) already will return PT24H or normalization-equivalent (for the V2 format of Edm.Time using XSD duration) or 24:00:00 (for the V4 format of Edm.TimeOfDay using XSD time), which is non-compliant with OData V2-V4 specifications.

      To improve interoperability, it would be preferable to standardize this behaviour.

      Note that the lexical format for XSD time permits 24:00:00, as it is the left-truncation of dateTime lexical representation, and dateTime lexical representation (see https://www.w3.org/TR/xmlschema-2/#dateTime) states:

      • hh is a two-digit numeral that represents the hour; '24' is permitted if the minutes and seconds represented are zero, and the dateTime value so represented is the first instant of the following day (the hour property of a dateTime object in the ¬∑value space¬∑ cannot have a value greater than 23);

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              handl Ralf Handl
            • Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: