In Spark, which function is used to extract the year from a date column?

In Spark, which function is used to extract the year from a date column?

• A. year
• B. extractYear
• C. dateYear
• D. getYear

Answer: (A)

Extracting the year from a date or timestamp is done with a dedicated date-time function in Spark. The year function takes a date or timestamp column and returns the year as an integer, for example: year(col("order_date")). This works directly in the DataFrame API and in Spark SQL (SELECT year(order_date) AS year FROM ...), making it the most straightforward and reliable way to obtain the year component. Other names aren’t standard Spark SQL functions, so they won’t work as written. If you needed a backup approach, you could use date_format(order_date, 'yyyy') to get the year as a string, but year is the preferred, idiomatic choice for an integer year.

Extracting the year from a date or timestamp is done with a dedicated date-time function in Spark. The year function takes a date or timestamp column and returns the year as an integer, for example: year(col("order_date")). This works directly in the DataFrame API and in Spark SQL (SELECT year(order_date) AS year FROM ...), making it the most straightforward and reliable way to obtain the year component.

Other names aren’t standard Spark SQL functions, so they won’t work as written. If you needed a backup approach, you could use date_format(order_date, 'yyyy') to get the year as a string, but year is the preferred, idiomatic choice for an integer year.