SQLITE datetime for different timzone required, not only localtime
<p>I want to fetch date and time, in different timezone using SQLITE. Say, I get the value as, 20160118T010856 in input, but I require it to change to Australian, England and other timezone.</p>

<p>What I am currently able to do is :</p>

<pre><code> select datetime('2016-01-18T04:13:39','localtime'); 
</code></pre>

<p>Which only provides me for my current local time. Kindly help.</p>