rendering date/times from 64bit julian format?
Derek Eder <derek.eder at lungall.gu.se> writes:
Hellos, I have date/times in 64-bit Julian format, that is the number of milliseconds since 1 jan 1970 (or something like that). E.g., "1159884877406" For the life of me I can't figure out how to render these in a more readable format, e.g., "2006-10-04 23:12:93.191" (and I have tried to do my best searching the archives and help etc ...)
This should be close:
format(ISOdatetime(1970,1,1,0,0,0)+1159884877406/1000,"%Y-%m-%d %H:%M:%OS3")
[1] "2006-10-03 15:14:37.406" Beware the timezone issues though.
O__ ---- Peter Dalgaard ?ster Farimagsgade 5, Entr.B c/ /'_ --- Dept. of Biostatistics PO Box 2099, 1014 Cph. K (*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918 ~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk) FAX: (+45) 35327907