title: How to convert a column in a data.frame from POSIXct to date in R
body: <p>I am reading data from an excel file and in one column I have dates which are read as POSIXct in the data.frame.</p>
  
  <p>Here the content of this column:</p>
  
  <pre><code>&gt;RawData_Date&lt;-read_excel(path=excel_file,range=rangedate,
          col_types="date", col_names= FALSE)
  &gt;str(RawData_Date)
  Classes ‘tbl_df’, ‘tbl’ and 'data.frame':   1000 obs. of  1 variable:
  $ X__1: POSIXct, format: "1963-01-01" "1963-01-02" "1963-01-03" "1963-01-04" ...
  </code></pre>
  
  <p>Later on in my code I got a date-time value <code>"1963-01-01 01:00:00"</code> which might be due to the manipulation, but I do not need and do not care about the time part, so I would like to convert the whole column to a date type as early as possible after reading the excel file.</p>
  
  <p>Which is the most elegant way to do so?</p>