Skip to Content
0
Sep 13, 2019 at 08:54 AM

Convert epoch timestamp to date/time in calculation view

1131 Views

Hello,

I built a calculation view on top of SAP COMMENTARY_MASTER table. int COMMENTARY_MASTER there are several timestamps. How can I convert those epoch time stamps to human readable date/time format in my calculation view?

I created a new calculated column, but when using addseconds(longdate(1970,01,01),decfloat("LASTMODIFIEDTIMESTAMP")) I get error message

Error: [303]: invalid DATE, TIME or TIMESTAMP value: invalid calculated date/time value at function add_seconds() (at pos 0)

LASTMODIFIEDTIMESTAMP has values like 1550486237356

Can anyone help me?

Thx,

Alexander Oertel

Attachments

formula.jpg (37.0 kB)