title: Convert timestamp/date time from UTC to EST Oracle SQL
body: <p>I have a field with a date/time value like this:</p>
  
  <pre><code>2009-11-17 18:40:05
  </code></pre>
  
  <p>It's in UTC. In the query how can I convert this to EST?</p>
  
  <p>I'm trying something like this but it throws an error.</p>
  
  <pre><code>// datetime is the field name
  SELECT 
     FROM_TZ(TIMESTAMP TO_DATE(datetime, 'yyyy-mm-dd hh24miss'), 'EST') AS DT
  FROM
     db_name
  </code></pre>