How to format into single date_time from mixed date_times(as factor)

Asked May 10 '17 at 05:56

Active May 10 '17 at 05:58

Viewed 38 times

I have column as date (factor data type) with mixed date_times as a factor

date
2014-12-30 12:00:00
30-12-2014 12:00:00
12/30/2014 12:00:00 
30-Dec-2014 12:00:00

How to format above date-time with R format like 2014-12-30 12:00:00

I have tried

library(anytime)
anytime(as.factor("df$date"))

edited May 10 '17 at 05:58

David Arenburg

asked May 10 '17 at 05:56

snr123

1

Why not just `anytime(df$date)`? What's up with the `as.factor` and the quotes? – David Arenburg May 10 '17 at 06:00
Relevant - http://stackoverflow.com/questions/42102462/r-changing-date-format-in-one-column-that-contains-two-date-formats/42102572 - where Dirk discusses how ddmmyy and mmddyy in the same data is not going to play nicely. My answer there might be helpful too. – thelatemail May 10 '17 at 06:03
I have tried but throwing error as : Error in inherits(x, "POSIXt") : object 'df' not found – snr123 May 10 '17 at 06:03
Then your data set isn't called `df`, eh? What the name of your data set? – David Arenburg May 10 '17 at 06:14
x <- c("2014-12-30 12:00:00", "30-12-2014 12:00:00", "12/30/2014 12:00:00", "30-Dec-2014 12:00:00" ) – snr123 May 10 '17 at 06:31
library(anytime) anytime(x,"%d-%m-%Y %H:%M:%S") – snr123 May 10 '17 at 06:34
Warning message: In as.POSIXlt.POSIXct(x, tz) : unknown timezone '%d-%m-%Y %H:%M:%S' – snr123 May 10 '17 at 06:35
just do `anytime(x)` – Ronak Shah May 10 '17 at 06:39
You are passing a format into the timezone parameter. You should really read the docs. It's only one function. – David Arenburg May 10 '17 at 06:42

0 Answers0