Extract: same as date_part.

Extract: same as date_part.

• A. Date_Part
• B. Extract
• C. Group By
• D. Having

Answer: (B)

When you want to pull out a specific component from a date or timestamp, you use a date-time part function. The standard form is Extract, which takes the part you want (like YEAR, MONTH, DAY) and the date value, returning that numeric component. In PostgreSQL, date_part provides the same result but with a different function signature, so both achieve the same goal. So Extract is the best match for “same as date_part” because it is the conventional way to extract a date component, while date_part is simply another function that does the same thing. The other items aren’t about pulling date components: they’re about organizing data (Group By) or filtering groups (Having).

When you want to pull out a specific component from a date or timestamp, you use a date-time part function. The standard form is Extract, which takes the part you want (like YEAR, MONTH, DAY) and the date value, returning that numeric component. In PostgreSQL, date_part provides the same result but with a different function signature, so both achieve the same goal.

So Extract is the best match for “same as date_part” because it is the conventional way to extract a date component, while date_part is simply another function that does the same thing. The other items aren’t about pulling date components: they’re about organizing data (Group By) or filtering groups (Having).