Remove seconds from time in R

anitasp picture anitasp · Sep 28, 2016 · Viewed 12.4k times · Source

I am trying to remove the seconds from a column of hours in POSIXct format:

#"2016-04-02 10:33:45 COT" "2016-04-02 22:19:24 COT"
#"2016-04-09 17:47:13 COT" "2016-04-13 16:56:23 COT"

x <- structure(c(1459589625, 1459631964, 1460220433, 1460562983),
     class = c("POSIXct", "POSIXt"), tzone = "")

I am trying this but I am not seeing results:

y <- as.POSIXct(x, format = "%d/%m/%Y %H:%M")

Answer

statquant picture statquant · Sep 28, 2016

No you are giving as.POSIXct a wrong format...

What about using format

datetimes = as.POSIXct(c("2016-04-02 10:33:45 COT", "2016-04-02 22:19:24 COT" ,"2016-04-09 17:47:13 COT", "2016-04-13 16:56:23 COT")    
format(datetimes,format='%Y%m%d %H:%M')

[1] "20160402 10:33" "20160402 22:19" "20160409 17:47" "20160413 16:56"