year

datetime

Extracts the year from a date or timestamp

Syntax

year(date)

date (date|timestamp)

The date value to extract the year from

number

The year as a four-digit number

Input:

year("2024-03-15")

Output:

Get the current year

Input:

year(now())

Output:

The year() function extracts the year component from a date or timestamp value.

Use year() to group data by year, filter records by time period, or extract temporal components for analysis.