SAP Knowledge Base Article - Public

3634240 - Timestamp column format change in OData URL in SAP Datasphere

Symptom

Timestamp columns have 8 digits of precision, whereas before they had 3.

Environment

SAP Datasphere

Reproducing the Issue

  1. Access the DS environment via the provided URL.
  2. Examine the timestamp column in the views.

Cause

The current behavior is correct according to the SAP HANA database timestamp format and matches the precision defined in the metadata response of the OData API.

Resolution

  1. Adapt the integration to follow the metadata definition of the model being consumed as all data should be in that format.
  2. Refer to the metadata definition of the specified view's column, which is of type Edm.DateTimeOffset with a precision of 7, indicating 7 fractional digits.

See Also

OData Version 4.0 Part 3: Common Schema Definition Language (CSDL) Plus

Datetime Data Types | SAP Help Portal

Keywords

timestamp, format change, odata, sap datasphere, Edm.DateTimeOffset, metadata definition, fractional digits, SAP HANA Cloud Database, integration adjustment , KBA , DS-BB-ODATA , To address issues related to Odata consumption API , Problem

Product

SAP Datasphere all versions