title: Remove the time from datetime.datetime in pandas column
body: <p>I have a pandas column called <code>'date'</code>
  which has values and type like <code>2014-07-30 00:00:00 &lt;class 'datetime.datetime'&gt;</code>.
  I want to remove the time from the date.The end result being `2014-07-30' in datetime.datetime format.  </p>
  
  <p>I tried a bunch of solutions like-</p>
  
  <pre><code>df['PSG Date '] = df['PSG Date '].dt.date
  </code></pre>
  
  <p>but its giving me error-</p>
  
  <pre><code>AttributeError: Can only use .dt accessor with datetimelike values
  </code></pre>