title: Converting a number to datetime sql
body: <p>I have the number 20080331.</p>
  
  <p>I need to cast/convert this into a datetime so I can do a date comparison within the database. How will i go about converting this number. Using CONVERT(DATETIME, Value) does not seem to work.</p>