Timestamp and right timezone in CDS VIews ABAP Cloud Project

[filipagatic]

Hello together,

i need help facing a problem in CDS Views Development. I am working in S/4HANA Public Cloud. 

cast((substring(cast(tstmp_current_utctimestamp() as abap.char(20)), 9, 6)) as abap.dec(31,14)) / 10000 as CurrentTime,

This code gives me the value i want, but the timezone is utc. i need it +2 hours, because i am in germany. I could do it manually, but when the time changes in winter i would have to change it again. is there any way to change the timezone to the local time zone somehow?

Thanks in advance

Filip

[junwu]

don't know your scenario, usually it is not good idea to do this kind of thing at backend. just like the number 1000, you don't format it at backend as 1.000 to send to frontend.

[filipagatic]

Hi,

thanks for your answer. I know, but i need it for a custom development case and do not know how to solve it in another way.

[junwu]

do it at frontend.