YEAR

​

Syntax

​

Scalar

year(value)

​

Arguments

​

Returns

• Type: INTEGER
• NULL behavior: Returns NULL for NULL input. Some date/time components also return NULL when the input is outside their supported calendar range.

​

Properties

​

Usage notes

• Returns an INTEGER component, or NULL for a NULL input.
• YEAR and MONTH can extract components from a wider range of UTC or timezone-free dates than other fields.

​

Examples

​

Extract a component

SELECT year(DATE '2024-01-01') AS result;

​

NULL input

SELECT year(CAST(NULL AS TIMESTAMP)) AS result;

​

Limitations

• String inputs require conversion to a date or timestamp. Use the formats shown here; the example does not cover every date or time format.