[OASIS Issue Tracker] Commented: (ODATA-14) add Edm.Date to the OData primitive data types

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

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

Evan Ireland commented on ODATA-14:
-----------------------------------

I would like to add my support for the addition of a Date data type, as distinct from DateTime.
I recently requested some real-life data models from enterprise mobility customers, and collected statistics for utilization of the various data types used (which in our enterprise mobility data models, are based on XML schema data types).

Model 1: {boolean=1, date=13, dateTime=1, decimal=35, int=172, long=5, string=1318, time=2}

Model 2: {boolean=1, date=13, dateTime=1, decimal=35, int=172, long=29, string=1482, time=2}

Model 2: {boolean=1, date=15, dateTime=2, decimal=35, int=172, long=38, string=1520, time=3}

Model 4: {boolean=1, date=40, dateTime=2, decimal=36, double=1, int=172, long=68, string=2009, time=15}

Model 5: {boolean=1, date=54, dateTime=2, decimal=43, double=1, int=172, long=83, string=2176, time=23}

Model 6: {boolean=1, byte=1, date=56, dateTime=2, decimal=53, double=1, int=172, long=94, string=2337, time=25}

You will note that in all cases, the "date" data type is far more prevalent than dateTime (also note that "time" is more prevalent than dateTime).

Such a significant prevalence of "date" in real-life customer data models calls for recognition of this in OData Models as a separate type from DateTime.

Note that in all the above cases the data types (date, time and dateTime) are without zone offset. I will comment on that in a separate issue.

> add Edm.Date to the OData primitive data types
> ----------------------------------------------
>
>                 Key: ODATA-14
>                 URL: http://tools.oasis-open.org/issues/browse/ODATA-14
>             Project: OASIS Open Data Protocol (OData) TC
>          Issue Type: Improvement
>          Components: OData CSDL v1.0
>            Reporter: Andrew Eisenberg
>            Assignee: Ralf Handl
>
> The addition of Edm.Date to the OData primitive data types might be considered. 
> Date values are widely used. SQL supports the DATE data type. XML Schema supports the xs:date data type. 
> Example:
>       <ComplexType Name="DeliveryFormatAvailability">
>         <Property Name="Available" Type="Edm.Boolean" Nullable="false" />
>         <Property Name="AvailableFrom" Type="Edm.Date" Nullable="true" />
>         <Property Name="AvailableTo" Type="Edm.Date" Nullable="true" />
>         <Property Name="Rating" Type="Edm.String" Nullable="true" MaxLength="Max" Unicode="true" FixedLength="false" />
>         <Property Name="Runtime" Type="Edm.Int32" Nullable="true" />
>       </ComplexType>

-- 
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