title: Convert UTC time to specific time zone in oracle
body: <p>I have to convert UTC time to some specific time zone, I have converted the sysdate to UTC,now I want to convert it to time zone specific, This is how I am converting sysdate to UTC</p>
  
  <pre><code>select cast(sys_extract_utc(systimestamp) as DATE) from dual;
  </code></pre>
  
  <p>I tried writing +5 before from keyword,but its returning the date after 5 days.</p>
  
  <pre><code>select cast(sys_extract_utc(systimestamp) as DATE)+5 from dual;
  </code></pre>
  
  <p>I have get the timezone offset with below query, but I have clue to use this in above query</p>
  
  <pre><code>SELECT TZ_OFFSET('US/Eastern') FROM DUAL;
  </code></pre>
  
  <p>How can I convert the UTC time to some timezone offset,something like below</p>
  
  <pre><code>select cast(sys_extract_utc(systimestamp) as DATE) from dual where TZ_OFFSET=+5;
  </code></pre>