Given a POSIXct date time, how do you extract the first day of the month for aggregation?
library(lubridate) full.date <- ymd_hms("2013-01-01 00:00:21")
lubridate has a function called floor_date which rounds date-times down. Calling it with unit = "month" does exactly what you want:
floor_date
unit = "month"
library(lubridate) full.date <- ymd_hms("2013-01-01 00:00:21") floor_date(full.date, "month") [1] "2013-01-01 UTC"
2.1m questions
2.1m answers
60 comments
57.0k users