Extract Date Format from Date Column using Extract?

I am trying to extract the DAY, MONTH, YEAR from a date column from my date column to create a dim_date table in my model.  Currently my code goes as follows: SELECT DISTINCT birthdate AS Date, Y...