• You're probably going to have to cut up the time and insert colons, using the substring (and if you like, left and right) functions, so that you end up with something you can cast to a date, at which point you can use the datediff function as intended.

    DECLARE @mydate VARCHAR(40)

    SELECT @mydate='20110621 10:42:32'

    SELECT CAST(@mydate AS DATETIME)