Add-Years

Returns a datetime value resulting from adding a number of years to a date.

Syntax

add-years (date_exp | datetime_exp, integer_exp)

Examples

add-years (today(), 10)

Returns the result: 03/20/2017 00:00

add-years (today(), -10)

Returns the result: 03/20/1997 00:00