SAP Knowledge Base Article - Public

3634240 - Timestamp column format change in odata url in SAP Datashphere

Symptom

Timestamps columns are having 8 digits precision which was 3 before

Environment

SAP Datashphere

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 considered correct according to the SAP HANA (Database) Timestamp format and matches the precision informed 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

Refer to:

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