New post
Question
· Jun 13, 2020

Timestamp conversion: 1591891200000 >>2020-06-12 00:00:00

#Ensemble

Hi :

    1591891200000 

      How do I convert the timestamp above to something like this format : 2020-06-12 00:00:00

Discussion (2)0
Log in or sign up to continue
Robert Cemper · Jun 13, 2020

Allmost!  3rd Update

since if the left side is a Unix Timestamp, then you get this result:

write $zdt($zdth(1591891200000\1000,-2),3) ==> 2020-06-11 18:00:00

docs: https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=RCOS_fzdatetime 

timezone conversion from UTC may compensate  the 6 hours difference ! 
 in Middle Europ we have we have 2 hrs+  to UTC so

write $zdt($zdt($zdth(1591891200000\1000,-2),-3),3)
2020-06-11 16:00:00
2 0