title: Sqlite update day on datetime
body: <p>I am trying to update just the day component on a datetime field on my sqlite database using:</p>
  
  <pre><code>UPDATE recur SET start_date = date('%d', '05')
  </code></pre>
  
  <p>I have read the documentation but cannot seem to figure out how to do this, can anyone help?</p>