R: Converting timestamp to date

Question

I have a timestamp pulled from MongoDB

example: 2007-01-01 01:00:00

I need it to be a simple date: 2007-01-01

Been looking at: Convert UNIX epoch to Date object

Having a hard time formatting

Answer 1

Using sources: Convert column in data.frame to date

I had to assess if the class that I was trying to convert was a class that as.Date was able to take.

Turns out it was a data.frame class

Used the following to convert it:

dat_dump %>%
            mutate( date = as.Date(date, format = "%Y-%m-%d"))