CODEWITHSUNDEEP
rdplyr
kamome
kamome

Reputation: 858

How to format properly date-time column in R using mutate?

I am trying to format a string column to a date-time serie.

The row in the column are like this example: "2019-02-27T19:08:29+000"

(dateTime is the column, the variable)

mutate(df,dateTime=as.Date(dateTime, format = "%Y-%m-%dT%H:%M:%S+0000"))

But the results is: 

2019-02-27

What about the hours, minutes and seconds ?

I need it to apply a filter by date-time

Upvotes: 5

Views: 22781

Answers (1)

JBGruber
JBGruber

Reputation: 12420

Your code is almost correct. Just the extra 0 and the as.Date command were wrong:

library("dplyr")
df <- data.frame(dateTime = "2019-02-27T19:08:29+000",
           stringsAsFactors = FALSE)

mutate(df, dateTime = as.POSIXct(dateTime, format = "%Y-%m-%dT%H:%M:%S+000"))

Upvotes: 5

Related Questions