title: How to convert long value 20130901 into smalldatetime
body: <p>If I have a long value <code>20130901</code>, how could I convert it to <code>smalldatetime</code>:</p>
  
  <pre><code>2013-09-01 00:00:00
  </code></pre>