• you can simply do this by below code:
    declare @table table (
    dated varchar(50)
    )

    insert into @table values('2017-feb-16')
    select * from @table
    select datepart(mm,dated) from @table