title: SQLite trim end characters from string
body: <p>Using SQLite.</p>
  
  <pre><code>ltrim(ltrim(substr(tablename.time, 11),'0123456789'),'-') as main_time
  </code></pre>
  
  <p>I have the above <code>trim</code> function which removes the first 11 characters from my string below.</p>
  
  <pre><code>2013-10-28 09:29:57.987 -- Original String.
  09:29:57.987            -- New String.
  </code></pre>
  
  <p>However I'd still like to remove the last four characters from the end of the string, turning it into the below:</p>
  
  <pre><code>09:29:57
  </code></pre>