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: : 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?