Convert 8 Digit Number into Date in SQL
<p>I have a date field that is pulling from a server as just an 8 digit number, and I would like to convert it to a standard date format.</p>

<p>For example, "<code>20140501</code>" would be converted to <code>05-01-2014</code></p>

<p>I tried using the <code>DateTime</code> code, but that didn't work for me. Any suggestions?</p>