title: Sqlite3 conversion MM/DD/YY string to YYYY-MM-DD
body: <p>I am trying to convert a string column of existing values from 'MM/DD/YY' to  'YYYY/MM/DD'.  </p>
  
  <p>Example Data:</p>
  
  <p>Table: backlog_backlogData</p>
  
  <p>[LoadDate]<br/>
  06/29/18<br/>
  06/29/18<br/>
  06/28/18<br/>
  07/24/18<br/>
  07/24/18<br/></p>
  
  <p>I have tried this (in SQLite Manager FireFox extention):</p>
  
  <pre><code>UPDATE backlog_backlogData SET LoadDate = substr(LoadDate, 7, 2)||”-“||substr(LoadDate, 1,2)||”-“||substr(LoadDate, 4,2)
  </code></pre>
  
  <p>Unfortunately, the column is updated with only the first substr (results: 18).  It seems like SQLite does not like concatenates ||?</p>
  
  <p>I've searched for an answer and have not found anything that works.</p>
  
  <p>Thanks for you time.</p>