title: Athena Select Query to Covert UTC timestamp to Required zone timestamp format
body: <p>I tried below query in Athena getting output with extra string "America/New_York", not in the expected format, need to remove the extra string from the value using athena query</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT execution_date, execution_date AT TIME ZONE 'America/New_York' as us,AT_TIMEZONE(execution_date, 'America/New_York') as us2 FROM "db"."table" limit 3;
  </code></pre>
  
  <p>Output of above query:</p>
  
  <pre><code>execution_date                  us                                              us2 
  2019-12-04 13:50:47.000 2019-12-04 08:50:47.000 America/New_York    2019-12-04 08:50:47.000 America/New_York 
  </code></pre>
  
  <p>expected output:</p>
  
  <pre><code>execution_date                  us                                              us2 
  2019-12-04 13:50:47.000   2019-12-04 08:50:47.000                       2019-12-04 08:50:47.000 
  </code></pre>
  
  <p>if any more information required please let me know.</p>