Timestamp conversion: 1591891200000 >>2020-06-12 00:00:00
Hi :
1591891200000
How do I convert the timestamp above to something like this format : 2020-06-12 00:00:00
Discussion (2)0
Comments
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
2020-06-11 16:00:00
Thank you !