Dates & time Scalar

year()

Extract the year component from a date or timestamp

Arguments & returns

4 overloads

Scalar

SELECT year(timestamp '2021-08-03 11:59:44.123456');

Haybarn WASM 1.5.6-rc6 · In your browser

Engine example · Run to view results.

YEAR('2021-03-01')

In DuckDB

YEAR(CAST('2021-03-01' AS DATE))