Re: [R] How to convert SPSS date data to dates?

From: Peter Dalgaard <p.dalgaard_at_biostat.ku.dk>
Date: Fri 17 Feb 2006 - 04:42:27 EST

"Jonathan Williams" <jonathan.williams@pharmacology.oxford.ac.uk> writes:

> Dear R Helpers,
>
> I have imported an SPSS file that contains date data.
> The data appear in R in a numeric format, as follows:
>
> 10485849600 10477641600 10561104000 10562745600 etc.
>
> I'd be extremely grateful if someone could tell me
> how to make these numbers into comprehensible dates!

> c(10485849600,10477641600,10561104000,10562745600)+ISOdate(1582,10,14)
[1] "1915-01-26 13:00:00 CET" "1914-10-23 13:00:00 CET" [3] "1917-06-15 13:00:00 CET" "1917-07-04 13:00:00 CET" Does this look right? (If you don't want the times, use as.Date).

BTW: There's a strange asymmetry:

> ISOdate(1582,10,14)+
> c(10485849600,10477641600,10561104000,10562745600)
[1] "1915-01-26 12:00:00 GMT" "1914-10-23 12:00:00 GMT" [3] "1917-06-15 12:00:00 GMT" "1917-07-04 12:00:00 GMT" (have we seen this before?).

-- 
   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@biostat.ku.dk)                  FAX: (+45) 35327907

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Received on Fri Feb 17 04:52:47 2006

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:42:31 EST