Postgresql how to change current_date to GMT+5:30 or ISTor Asia/Kolkata timezone
<p>I am using postgreSQL . I need to find date as <code>yyyy-mm-dd</code>.</p>

<p>What I did is as follows:</p>

<pre><code>select from current_date;
</code></pre>

<p>It works fine. But <strong>I need it with respect to Indian timezone ,I mean GMT+5:30/(Asia/Kolkata)</strong>. My datatype in storing column is <code>date</code>.</p>

<p>I have tried as:</p>

<pre><code>select current_date AT TIME ZONE 'Asia/Kolkata'
</code></pre>

<p>What I am getting is timezone as type of output. I need datatype in date.</p>