title: How to remove trailing 0s and offset from Oracle db
body: <p>I'm working with an Oracle database (version 12c) containing a <code>date</code> column with the dates in the format <code>YYY-MM-DD H23:Mi:SS</code>.</p>
  <p>All the dates are stored in EST.</p>
  <p>I'm converting these dates to UTC so <code>2021-09-23 09:12:22</code> would appear as <code>2021-09-23 14:12:22</code>.</p>
  <p>I have the following query:</p>
  <pre><code>SELECT my_date,
         FROM_TZ(CAST(my_date AS TIMESTAMP), 'America/New_York') AT TIME ZONE 'UTC' AS my_date_utc
  FROM my_table
  </code></pre>
  <p>Here is a sample of my results:</p>
  <pre><code>my_date               my_date_utc
  -------------------   -------------------
  2018-04-28 21:21:26   2018-04-29 01:21:26.000000 +00:00
  2018-12-18 07:42:25   2018-12-18 12:42:25.000000 +00:00
  </code></pre>
  <p>How do I remove the &quot;.000000 +00:00&quot; from the results? So the result would appear as:</p>
  <pre><code>my_date               my_date_utc
  -------------------   -------------------
  2018-04-28 21:21:26   2018-04-29 01:21:26
  2018-12-18 07:42:25   2018-12-18 12:42:25
  </code></pre>