title: How to change date format in sqlite database
body: <p>How do I change the format of a date in %d/%m/%Y or any other from this string 10/09/2016 in sqlite?</p>
  
  <p>I have tried this but it is not working:</p>
  
  <pre><code>select strftime('%d/%m/%Y', '09-10-2016'),t_date from party_trans 
  </code></pre>