Date_Part: pulls out a specific date part from a date.

Date_Part: pulls out a specific date part from a date.

• A. Extract
• B. Date_Part
• C. Substring
• D. Year

Answer: (B)

Pulling out a specific piece of a date, such as the year, month, or day, from a full date value is about extracting one date component rather than the whole date. The Date_Part function is designed for this exact task: you specify which part you want and provide the date, and it returns that single component. For example, DATE_PART('YEAR', order_date) would yield the year portion of order_date, like 2026. This makes it the correct tool for obtaining a specific date part. The other options don’t fit as the primary mechanism here: Substring is for slicing strings, not dates. Year refers to the part you want, not the function to extract it. Extract is another name used in some SQL dialects, but the item being tested points to Date_Part as the function used to pull a specific date component.

Pulling out a specific piece of a date, such as the year, month, or day, from a full date value is about extracting one date component rather than the whole date. The Date_Part function is designed for this exact task: you specify which part you want and provide the date, and it returns that single component. For example, DATE_PART('YEAR', order_date) would yield the year portion of order_date, like 2026. This makes it the correct tool for obtaining a specific date part.

The other options don’t fit as the primary mechanism here: Substring is for slicing strings, not dates. Year refers to the part you want, not the function to extract it. Extract is another name used in some SQL dialects, but the item being tested points to Date_Part as the function used to pull a specific date component.