IBM PureData System for Analytics, Version 7.1

The next_year() function

The next_year() function determines the first day of the next year after the date specified by the input.

Description

The next_year() function has the following syntax:

date = next_year(date input);

The input value specifies a date.

Returns a date value that represents the first day of the next year after the date specified by the input. For example:

select next_year('1996-2-29');
 NEXT_YEAR
------------
 1997-01-01
(1 row)