Date Issue in HDI Container in SAP Cloud Platform

[Phani_Kumar]

Hello ,

I am using SAP Cloud Platform and I am trying to update the data to one of my HDI Containers using XSODATA.

I was able to update data into my HDI Containers. But ChangedOn Field is always getting a wrong time in DB.

Assume time now is 11:56 AM in Italy. and If I click on save , it shows me LASTCHANGEDON : 11:56 (GMT +2 HOURS Central European Summer Time)

but when I look into the DB ,It shows me 28-07-2020 09:56:00 something like this. I can always see 1 or 2 hours difference in the UI. May I know how to save the correct value in DB and also show the same in UI without any offset hours.

[gregorw · Accepted solution]

Looks fine to me when the DB stores the time in UTC. Display in the frontend UI5 app converts it to the timezone set in the Operating System of the Browser. Have you looked on the OData payload?

[Phani_Kumar · Accepted solution]

Hi gregorw ,

In the payload , data is coming as shown below .

"VERSION": 1,

"ITEMID": 1,

"CREATEDAT": "/Date(1595927785360)/",

"BASEVALUE": null,

So you think, nothing needs to be changed as the UI is showing the date time based on the locale settings?