• Actually, you could do an implicit or explicit conversion....

    'implicit'

    SET @DateTimeVariable = @CharVariableContainingDateString

    vs.

    'explicit'

    SET @DateTimeVariable = convert(datetime,@CharVariableContainingDateString)