[R] rendering date/times from 64bit julian format?

[Peter Dalgaard]

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