YEAR

Returns the year from a timestamp value.

Syntax

YEAR(timestamp)

Name	Type	Description	Default Value
timestamp	timestamp

bigint

timestamp	Output
timestamp "2018-03-10 08:55:12.456"	2018

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!