Year

Summary

The Year function returns the year as a numeric value for the specified date/time.

Syntax

Year(<date|date_time|instant|offset_date_time|zoned_date_time>)

Return Type

Integer

Details

Nothing else to add here.

Examples

eval Year(ToDate(‘2042-04-01’));

screen-shot-2016-09-21-at-10-55-44-am

select date1, Year(date1), Year(date_time1), Year(offset_date_time1), Year(zoned_date_time1) from AllTypes();

screen-shot-2016-09-21-at-10-55-38-am

Related Functions

DayOfMonth

DayOfWeek

DayOfYear

Month

Quarter

Week