• You can't have two different data types in the same column, your effectivly saying I want DATETIME and VARCHAR data in the same column which is not allowed.

    You will need to do a double cast

    cast(cast(col2 as datetime) as varchar)