Comment by jimktrains2

> DATEDIFF('year', '12-31-2020', '01-01-2021') returns 1 because even though the two dates are a day apart, they've crossed the year boundary.

What is the use of such a function? If I saw this answer I would assume a bug somewhere (until reading the documentation).