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’));
select date1, Year(date1), Year(date_time1), Year(offset_date_time1), Year(zoned_date_time1) from AllTypes();