You can also be lazy and use
SELECT SUBSTRING (CAST (dob AS NVARCHAR),6,2)
Works just fine. That's if its a date field. For Datetime it might be abit tasking as you must convert it to a date time first, i.e
SELECT SUBSTRING (CAST (CAST(dob AS DATE) AS NVARCHAR),6,2)