YEARS_DIFF
Description
Calculates the difference in years between two datetime values.
Syntax
YEARS_DIFF(<enddate>, <startdate>)
Parameters
Parameter | Description |
---|---|
<enddate> | The end date, which can be of type DATETIME or DATE |
<startdate> | The start date, which can be of type DATETIME or DATE |
Return Value
Returns a value of type INT, representing the number of years between the two dates.
Example
SELECT YEARS_DIFF('2020-12-25', '2019-10-25');
+----------------------------------------------------------+
| years_diff('2020-12-25 00:00:00', '2019-10-25 00:00:00') |
+----------------------------------------------------------+
| 1 |
+----------------------------------------------------------+