Is there a way to convert a timestamp from this format into a readable human date?
I have generated the timestamp using JavaScript:
Date.now();
An example of the output is:
1468833354929
After storing it in a database, when I attempt to convert it using R:
date <- as.POSIXct(1468833354929, origin="1970-01-01", tz="Asia/Singapore")
The result I get is:
48515-06-24 09:15:29 SGT
However, the expected output should be:
2016-07-18 09:15:29 SGT
Do you have any suggestions on why this is happening and how I can achieve the correct human-readable date-time format?