title: How to convert time zones in oracle?
body: <p>I have a list from peoplesoft timezones which i need to convert using From_TZ method. The time zones will be in a format as EST,IST..etc.</p>
  
  <pre><code>select FROM_TZ (CAST ( (:dt) AS TIMESTAMP), 'EST')
            AT TIME ZONE 'IST' from dual
  </code></pre>