IBM PureData System for Analytics, Version 7.1

The this_year() function

The this_year() function determines the first day of the year in the specified date.

You can also determine the first day of the year value by using the IBM® Netezza® date_trunc() function.

Description

The this_year() function has the following syntax:

date = this_year(date input);

The input value specifies a date.

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

select this_year('1996-2-29');
 THIS_YEAR
------------
 1996-01-01
(1 row)