How to get a month and year from date string in SQL

SQL DATEPART() function is used to get a part of any specific date , it could be a day , month ,year or time of specific date.