title: How do you convert a timestamp with nano-seconds to just seconds with Pandas?
body: <p>I have a Windows Event logs which are in an ElasticSearch cluster.  I am using Pandas to query ES vis the API. The output for the datetime field is initially an &quot;object&quot;. Using pandas.to_datetime I have successfully converted it to a Dtype of &quot;datetime64[ns, UTC]&quot;.</p>
  <p>However the data in the field in an undesired format of, yyyy-mm-dd hh:mm:ss+00:00.</p>
  <p>I don't want the &quot;+00:00&quot; part. I have tried pandas.to_datetime with format to no avail. Here is how I am converting the object.</p>
  <pre><code>services[&quot;datetime&quot;]=pd.to_datetime(services[&quot;datetime&quot;])
  </code></pre>
  <p>Here is the field output, 2020-08-31 11:02:03+00:00
  Here is the desired output, 08/31/2020 11:02:03</p>
  <p>Not sure how to get there.</p>