3 weeks ago
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.
Thank you in advance for your guidance and suggestions!
Best regards,
Ganga Reddy Somu
Request clarification before answering.
Hi,
You can try using the below option:
TO_DATE(UTCTOLOCAL (CURRENT_UTCTIMESTAMP, 'EST') )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
53 | |
10 | |
8 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.