Introduction

According to the OData Version 2.0 specification, the following date and time related primitive data types exist:

1. Edm.Time - represents the time as, for example, PT17H15M, which corresponds to 17:15:00.

2. Edm.DateTime - represents the date and time as, for example, 2001-12-21T12:00, which corresponds to 12:00 PM on Dec 21, 2001.

3. Edm.DateTimeOffset - represents the date and time as an offset in minutes from GMT, with values from 12:00:00 midnight, January 1, 1753 A.D. through to 11:59:59 P.M, December 9999 A.D. For example, 1999-01-01T23:01:00Z corresponds to 11:01:00 PM on January 1, 1999.

Binding of time values to TimePicker

1. With a dedicated Edm.Time:

   Hidden

   <TimePicker displayFormat="short"
               value="{ path: 'EntryTime', type: 'sap.ui.model.odata.type.Time'}"/>
   

   The sample shows how to bind time values at the backend (for example PT11H33M55S for 11:33:55). Note that there is a dedicated data binding type that recognizes the Edm.Time format and can handle time conversions in both directions - from and to the backend. When you are working with this data binding type and you choose a value using the TimePicker control, the same value will be sent to the backend, that is, no timezone conversions will be applied to the value.

2. As a string:

   Hidden

   <TimePicker value="{EntryTimeString}" valueFormat="HH:mm:ss"/>

   In the above example, the apps give the TimePicker information about the exact format with which the time values are stored in the backend. The whole coding is string-based (the data field is a string, and the EDM type is an Edm.String) and no conversion is done.

   With the introduction of the property support2400 in version 1.54, this option may be used also if the apps need to differentiate between the beginning of a day (00:00:00) and the end of a day (24:00:00). For more information, see the API Reference and the Samples.

Binding of date values to DatePicker

<DatePicker value="{
	path: 'EntryDate',
	type: 'sap.ui.model.odata.type.DateTime',
	constraints: {
		displayFormat: 'Date'
	}
}" />

If you have date values at the backend, you should bind them as shown in the sample above. When exposing its database field (EntryDate) via OData, date values can be exposed both as Edm.DateTime and Edm.DateTimeOffset. The syntax for binding the DatePicker value property is the same in both cases.

Above you can see an example of the displayFormat constraint. It specifies if the given value should be interpreted as Date or DateTime (default). If Date is specified, the binding type performs the UTC conversion, which is always on. In other words, any local date chosen by the end user will be considered as a UTC date and sent as a UTC date to the backend.

Binding of date and time values to DateTimePicker

<DateTimePicker
        value="{ path: 'EntryDateTime', type: 'sap.ui.model.odata.type.DateTime' }"/>

In this example, the binding type specifies that the backend data will be interpreted as a date and time field.

Binding of date ranges

1. With a dedicated EDM type (Edm.DateTime, Edm.DateTimeOffset):

   Hidden

   <DateRangeSelection value="{parts: [{path: 'EntryDate'}, {path: 'EntryDateTimeOffset'}], type: 'sap.ui.model.type.DateInterval',
   formatOptions: { UTC: true, format: 'yMd' }}" />

   If you have two dates in the backend represented as Emd.DateTime and/or Edm.DateTimeOffset, you can bind them to the DateRangeSelection control as shown above.

2. As a string:

   If you have the date range provided with a single date formatted string field in the backend (for example, July 29, 2015 - July 31, 2015), use the value property in the following way:

   Hidden

   <DateRangeSelection
           value="{path: 'EntryDateRange', valueFormat: 'MMM d, y'}"/>
   

Note that you need to tell the DateRangeSelection the format of the dates stored in the backend. The format should denote the format of a single date. If the delimiter is different than "-", you need to additionally specify it in the property delimiter.