Forum Discussion
samsamsam
6 years agoNew Member
Convert UNIX timestamp to Date time
Hi,
I am trying to convert a UNIX time to normal date time display
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 8, 0,[dateTimeOrigination]/1000)However, it returns the year in Jan 1970. But the month and year should be Jun 2019.
Do I make any mistake here?
Thanks in advance
Sam
Hi,
Try removing the /1000 part of the code
2 Replies
- Gordonlilj
Solution Sage
Hi,
Try removing the /1000 part of the code
- samsamsamNew Member
Gordonlilj it works perfectly , thank you~😁