Converting a number to datetime sql

Question

I have the number 20080331.

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.

Answer 1

SELECT  CONVERT(DATETIME, CAST(20110331 AS VARCHAR(8)), 112)