The table STUDENTS has an attribute BIRTH$\_$DATE that holds the birth date of a student in a date format. Which of the following gives the birthday of a student?

YEAR$($BIRTH$\_$DATE$)$

TO$\_$DATE$($BIRTH$\_$DATE, $\text{'}\%$ Y$-\%$ M$\text{'})$

TO$\_$DATE$($BIRTH$\_$DATE, $\text{'}\%$ M$-\%$ D$\text{'})$

TO$\_$DATE$($BIRTH$\_$DATE, $\text{'}\%$D$\text{'})$