Symptom
When using the CURRENT_TIMESTAMP function the system displays the server time (UTC), however it is expected that the time needs to be synced with client time.
Environment
SAP Datasphere
Resolution
- Use a calculated column with the UTCTOLOCAL function. For example, use UTCTOLOCAL(CURRENT_TIMESTAMP , 'Europe/Madrid').
- For more information, refer to the Help guide reference: UTCTOLOCAL Function (Datetime)
Keywords
sap datasphere, dwc, ds, timezone, utc , KBA , DS-MD , Modeling (Data Builder) , Problem
Product
SAP Datasphere all versions