title: how to apply strftime on localtime
body: <p>I want to get the day of the month from a datetime column in my Sqlite database. I could use simply </p>
  
  <pre><code>select strftime('%d',myColumn) from myTable
  </code></pre>
  
  <p>But the values are stored in UTC in the database and i want to get the dates based on the localtime. So i can do the below to get the localtime.</p>
  
  <pre><code>select date(myColumn, 'localtime') from myTable
  </code></pre>
  
  <p>Now how do i do both these operations together? The only way i can think is by doing inner query with the <code>date()</code> and outer query with <code>strftime()</code>. Is there another way?</p>