title: Prestosql/Amazon Athena: Time Zone Change
body: <p>I need to change a UTC timestamp to 'US/Eastern' timestamp without changing the date and time - essentially update only the timezone information and later convert that to a different timezone.</p>
  <p>For example (what I need):</p>
  <p>'2021-06-09 19:00:36.000000' UTC --&gt;  '2021-06-09 19:00:36.000000' US/Eastern</p>
  <p>Then I need to convert that to 'America/New_York'.</p>
  <p>'2021-06-09 19:00:36.000000' US/Eastern --&gt; '2021-06-09 16:00:36.000000' America/Los Angeles</p>
  <hr />
  <p>When I try the query below, it's not giving me the correct results, since it is converting from UTC to America/Los Angeles. When it should be US/Eastern to America/Los Angeles.</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT id
  , date_utc 
  , CAST(date_utc AT TIME ZONE 'America/Los Angeles') AS date_la
  FROM call_records
  </code></pre>