title: Prestosql converting UTC timestamp to local?
body: <p>How can I convert a timestamp field that includes day and time to local time in Prestosql? The fields look like </p>
  
  <pre><code>Region ID  |         Start Time utc       |       End Time utc
  abc           2019-04-26 20:00:00.000   2019-04-26 23:00:00.000
  cdx           2019-02-27 23:30:00.000   2019-02-28 01:00:00.000
  </code></pre>
  
  <p>I have the Region IDS so if I need to or if it makes it easier I can enter in the query the ids of the timezone I would need for that row. </p>
  
  <p>I want to just return the local start and end time for that timezone.</p>
  
  <p>the query is </p>
  
  <pre><code>SELECT table1.*
  FROM table1
  WHERE table1.day = date '2019-04-03' AND
       NOT EXISTS (SELECT 1
                   FROM table2
                   WHERE table1.id = table2.id AND
                         table1.timestamp &gt;= table2.start_time AND
                         table1.timestamp &lt;= table2.end_time
                   )
  </code></pre>
  
  <p>Where table 2 is the start and end time in which I want to convert to local times...</p>
  
  <p>where the utc time is in the not exists clause for start and end time, how would I change that to local times ? not all the times would be the same timzone in america? There is a region Id field that I can use to link that region id to a timezone can I use that?</p>