Which of the following functions extracts a date component?

Which of the following functions extracts a date component?

• A. Count
• B. Avg
• C. Date_Part
• D. Sum

Answer: (C)

Date components from a date value are retrieved using a date-part function. Date_Part is designed to pull out a specific piece of a date, such as year, month, or day, by specifying which component you want and the date value. For example, Date_Part('month', order_date) returns the month number for each date. In contrast, Count counts rows or non-null values, while Avg and Sum compute numeric aggregates across rows. They don’t extract parts of a date, so they aren’t used for obtaining date components.

Date components from a date value are retrieved using a date-part function. Date_Part is designed to pull out a specific piece of a date, such as year, month, or day, by specifying which component you want and the date value. For example, Date_Part('month', order_date) returns the month number for each date. In contrast, Count counts rows or non-null values, while Avg and Sum compute numeric aggregates across rows. They don’t extract parts of a date, so they aren’t used for obtaining date components.