Search code examples
rdateformatextract

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


Solution

  • Are you looking for format?

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