ETL: GetYear

Extract the year component from a datetime expression. Use GETYEAR for annual aggregations, filtering, and date partitioning in ETL pipelines.

Description

Returns the year from a datetime expression.

Syntax

GetYear(datetime_expression)

Examples

GetYear(ToDate('2012-12-31T08:02:31.667Z')) returns 2012

Return value datatype

Integer

Impact of null value

If input is null, returns null.