Use the EXTRACT function to get the year, month, or day from a date. The result has INTEGER data type.