How to change date format in sqlite database
<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>