R lubridate converting seconds to date

r lubridate
broccoli picture broccoli · Dec 21, 2012 · Viewed 16.7k times · Source

I have a simple question regarding R's lubridate package. I've a series of timestamps in seconds since epoch. I want to convert this to YYYY-MM-DD-HH format. In base R, I can do something like this to first convert it to a date format

> x = as.POSIXct(1356129107,origin = "1970-01-01",tz = "GMT")
> x
[1] "2012-12-21 22:31:47 GMT"

Note the above just converts it to a date format, not the YYYY-MM-DD-HH format. How would I do this in lubridate? How would I do it using base R?

Thanks much in advance

Answer

leerssej picture leerssej · Oct 13, 2017

lubridate has an as_datetime() that happens to have UNIX epoch time as the default origin time to make this really simple:

> as_datetime(1356129107)
[1] "2012-12-21 22:31:47 UTC"

more details can be found here: https://rdrr.io/cran/lubridate/man/as_date.html

Related questions

How to extract Month from date in R

I am using the lubridate package and applying the month function to extract month from date. I ran the str command on date field and I got Factor w/ 9498 levels "01/01/1979","01/01/1980",..: 5305 1 1 1 1 1 1 1 1 1 ... > v1$Date<-month(v1$Date) Error in as.…

Read More
Convert character to class Date

I have a data frame with a character column of dates. When I use as.Date, most of my dates are parsed correctly, except for a few instances. The example below will hopefully show you what is going on. # my …

Read More
extract hours and seconds from POSIXct for plotting purposes in R

Suppose I have the following data.frame foo start.time duration 1 2012-02-06 15:47:00 1 2 2012-02-06 15:02:00 2 3 2012-02-22 10:08:00 3 4 2012-02-22 09:32:00 4 5 2012-03-21 13:47:00 5 And class(foo$start.time) returns [1] "POSIXct" "POSIXt" I'd like to create a plot of foo$duration v. foo$…

Read More