GabyLP GabyLP - 2 months ago 10
R Question

R Extract day from datetime

Hi I need to remain only with the day of each date:

df<-data.frame(x=c("2014-07-24 00:00:00",
"2014-07-24 00:00:00", "2014-07-11", "2014-07-11" ,"2014-07-16" ,"2014-07-14"))
as.Date(df$x,format="%Y-%m-%d" )


I tried this:

df$dia<-as.Date(df$x, format="%d")


But I get a full date and different from the orginal.

I don't want to install another package to do this.
How can I solve it?
Thanks

Answer

Are you looking for format?

format(as.Date(df$x,format="%Y-%m-%d"), "%d")
# [1] "24" "24" "11" "11" "16" "14"