_add_years

Adds "integer_expression" years to "date_expression". If the "date_expression" is February 29 and resulting year is non leap year, then the resulting day is set to February 28. In all other cases the returned value has the same day and month as "date_expression".

Syntax

_add_years ( date_expression, integer_expression )

Example 1

_add_years ( 2012-04-15 , 1 )

Result

2013-04-15

Example 2

_add_years ( 2012-02-29 , 1 )

Result

2013-02-28

Example 3

_add_years ( 2002-04-30 12:10:10.000 , 1 )

Result

2003-04-30 12:10:10.000