CODEWITHSUNDEEP
r
hyat
hyat

Reputation: 1057

How to add the time to a date when using as.date?

I have measurements that were taken at this time: 13880 and they represent "days since 1970-01-01 00:00:00"

So now I want to know the dat and time:

as.Date(13880, origin="1970-01-01")
[1] "2008-01-02"  # works fine

Now to add the time:

as.Date(13880, origin="1970-01-01",tz = "UTC",  format="%Y/%m/%d %H:%M:%S")
[1] NA

or

as.POSIXct(13880, origin="1970-01-01")
[1] "1970-01-01 04:51:20 CET"
as.POSIXlt(13879, origin="1970-01-01")
[1] "1970-01-01 04:51:19 CET"

None of these worked for me. Any idea?

Upvotes: 2

Views: 161

Answers (1)

C8H10N4O2
C8H10N4O2

Reputation: 19005

as.POSIXct(as.Date("1970-01-01") + 13880) # returns "2008-01-01 19:00:00 EST"
as.POSIXct(as.Date("1970-01-01") + 13880.5) # returns "2008-01-02 07:00:00 EST"

You can also set your time zone: How to change the default time zone in R? also: http://blog.revolutionanalytics.com/2009/06/converting-time-zones.html

Upvotes: 2

Related Questions