Question

A data engineer is building a Silver table for customer subscriptions. Each row has a `signup_date` and a `cancel_date` (both DATE type). The engineer needs a new column `tenure_months` that expresses the whole number of months between the two dates. Which Spark SQL expression produces the correct integer month count?

Accepted Answer

CAST(months_between(cancel_date, signup_date) AS INT) AS tenure_months

Answer

datediff(cancel_date, signup_date) / 30 AS tenure_months

Answer

months_between(signup_date, cancel_date) AS tenure_months

Answer

date_add(cancel_date, signup_date) AS tenure_months