GabyLP GabyLP - 1 year ago 123
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?

Answer Source

Are you looking for format?

format(as.Date(df$x,format="%Y-%m-%d"), "%d")
# [1] "24" "24" "11" "11" "16" "14"
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download