I have to do a difference between dates and return the number of days. the format of the dates is as follows:
12/9/2011 12:00:00 AM
Does anyone know how to perform the difference without using lubridate?
We can use asPOSIXct
to convert to DateTime
v1 <- as.POSIXct("12/9/2011 12:00:00 AM", format = "%d/%m/%Y %I:%M:%S %p")
If we need only Date
as.Date(v1)
Convert datetime column in date format
df$DATETIME<-as.Date(df$DATETIME)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With