Date Extraction — Solution & ExplanationProblems / Date Extraction / EditorialApproachEXTRACT pulls specific components from date/timestamp values.

EXTRACT(YEAR FROM event_date) returns the 4-digit year.

EXTRACT(MONTH FROM event_date) returns the month number (1-12).

You can also extract DAY, HOUR, MINUTE, SECOND, and other parts. DuckDB also supports shorthand functions like year() and month().Hints

EXTRACT(YEAR FROM date_col) pulls the year from a date or timestamp.

EXTRACT(MONTH FROM date_col) returns the month as an integer (1-12).

In PySpark, use F.year() and F.month() functions.