cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with UTCTOLOCAL Function in Data Flows (SAP Datasphere)

gangareddysomu
Discoverer
0 Kudos
139

Hi SAP Community,

I am encountering an issue while working on a calculated column (CD_SNAPSHOT_DATE) in Data Flows in SAP Datasphere.

We have  calculated columns in a Fact View to derive the current date using the following expression:

TO_DATS(UTCTOLOCAL(CURRENT_TIMESTAMP, 'US/Central')).

I need to create a Calculated Column similar to this in Data Flow For Snapshot Date if I use the above expression I am getting the below error:

UTCTOLOCAL function only supports UTC offset timezone formats.

To address this, I updated the expression to use a UTC offset format as follows:

1.TO_DATS(UTCTOLOCAL(CURRENT_TIMESTAMP, '-06:00'))

2.TO_DATS(UTCTOLOCAL(CURRENT_TIMESTAMP, 'UTC-6'))

However, this also throws the same error.

Questions:

  1. Does anyone know what UTC offset timezone formats are specifically supported in Data Flows?
  2. Are there any working examples or alternatives to dynamically handle time zones in Data Flows, especially for US/Central time?

Thank you in advance for your guidance and suggestions!

Best regards,
Ganga Reddy Somu

View Entire Topic
Yogesh_Rehadwa
Explorer
0 Kudos

Hi,

You can try using the below option:

TO_DATE(UTCTOLOCAL (CURRENT_UTCTIMESTAMP, 'EST') )

https://help.sap.com/docs/HANA_SERVICE_CF/7c78579ce9b14a669c1f3295b0d8ca16/20f52f4475191014a10892424...