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] (ODATA-1123) Allow 24:00:00 for Edm.TimeOfDay


    [ https://issues.oasis-open.org/browse/ODATA-1123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=67919#comment-67919 ] 

Steven Legg commented on ODATA-1123:
------------------------------------

This opens up the question of whether 24:00:00 equals 00:00:00. I can't find a formal definition in OData for comparing time values, but I do note that the XML Schema definition for time (https://www.w3.org/TR/xmlschema-2/#time) says 'the canonical representation for midnight is 00:00:00', which suggests that 24:00:00 must be normalized to 00:00:00. Also XQuery (https://www.w3.org/TR/xpath-functions/#date-time-values) has something to say on the matter of comparing time values: 'For xs:time, "00:00:00" and "24:00:00" are alternate lexical forms for the same value, whose canonical representation is "00:00:00"'.

> Allow 24:00:00 for Edm.TimeOfDay
> --------------------------------
>
>                 Key: ODATA-1123
>                 URL: https://issues.oasis-open.org/browse/ODATA-1123
>             Project: OASIS Open Data Protocol (OData) TC
>          Issue Type: New Feature
>          Components: CSDL JSON , CSDL XML
>    Affects Versions: V4.01_CSD03, V4.01_CSD02
>            Reporter: Ralf Handl
>             Fix For: V4.01_CS01
>
>
> 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);



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)


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