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

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

SAP Datasphere

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".

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.

UTCTOLOCAL Function (Datetime)

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