SAP Knowledge Base Article - Public

3522350 - How to find legal values of parameter "timezone" when use UTCTOLOCAL function in Views in Datasphere

Symptom

This article describes how to find legal values of parameter "timezone" when use UTCTOLOCAL function in Views in Datasphere.

Environment

SAP Datasphere

Reproducing the Issue

  1. Open Data Builder in Datasphere.
  2. Create a a SQL View or a Graphical View.
    1. Use UTCTOLOCAL in the SQL View. For example:
      SELECT UTCTOLOCAL(time,'EST') from "Time_Table" as timecolum
    2. Use UTCTOLOCAL in the Graphical View. For example:
      1. Create a Calculated Column.
      2. Input UTCTOLOCAL(time,'EST') into "Expression".

Resolution

  1. Logon Datasphere HANA Database as below document:
    Create a Database Analysis User to Debug Database Issues
  2. Open a SQL console and run below SQL to see all the timezones:
    SELECT TIMEZONE_NAME FROM SYS.TIMEZONES WHERE TIMEZONE_DATASET = 'platform'
  3. The names of all the time zones will be shown in the result. Choose one and use it for parameter "timezone".
    For example, UTCTOLOCAL(TIMESTAMP,'PST8PDT') for PST time.

See Also

UTCTOLOCAL Function (Datetime)

Keywords

KBA , DS-MD-VIW , Views , HAN-DB , SAP HANA Database , Problem

Product

SAP Datasphere 1.0