title: How to select datetime from ORACLE db using IST timezone
body: <p>Oracle database is hosted in US. Application server hosted in UK.</p>
  
  <p>I am trying to access the oracle application from India, how can I write a query that will show IST time. (Local machine time).</p>
  
  <p>This is an oracle form, so no coding can be done.</p>
  
  <p>Tried below but did not worked</p>
  
  <pre><code>SELECT 
  TO_CHAR(current_date, 'DD-MON-YYYY HH24:MI')
  FROM DUAL
  </code></pre>