title: Time zone conversion in SQL query
body: <p>I am using a query to get some application Received Date from Oracle DB which is stored as GMT. Now I have to convert this to Eastern standard/daylight savings time while retrieving.
  I am using the below query for this:</p>
  
  <pre><code>   select to_char (new_time(application_recv_date,'gmt','est'), 'MON dd, YYYY') from application
  </code></pre>
  
  <p>It works fine for Standard time. But for daylight savings time we need to convert it to 'edt' based on timezone info. I am not very sure on how to do this. Please help me out</p>