title: dt.date returns AttributeError: Can only use .dt accessor with datetimelike values
body: <p>All the values in the columns that I'm trying to use pd.to_datetime() on look like for example, 2017-10-02 10:56:33 </p>
  
  <p>So I ran the code below</p>
  
  <pre><code>
  order_time['order_purchase_timestamp'] = pd.to_datetime(order_time['order_purchase_timestamp'], errors='coerce')
  order_time['order_develiered_customer_date'] = pd.to_datetime(order_time['order_delivered_customer_date'], errors='coerce')
  </code></pre>
  
  <p>then I tried to do</p>
  
  <pre><code>order_time['date_order'] = order_time['order_purchase_timestamp'].dt.date
  order_time['date_delivered'] = order_time['order_delivered_customer_date'].dt.date
  </code></pre>
  
  <p>which returns the "AttributeError: Can only use .dt accessor with datetimelike values"</p>
  
  <p>I checked the dtype and they were </p>
  
  <pre><code>dtype('&lt;M8[ns]')
  </code></pre>
  
  <p>I can't figure what the problem is here.</p>