Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Atualizado 02/10/2024
Send us feedback
year
Applies to: Databricks SQL Databricks Runtime
Returns the year component of expr. This function is a synonym for extract(YEAR FROM expr).
expr
extract(YEAR FROM expr)
year(expr)
expr: A DATE or TIMESTAMP expression.
An INTEGER.
> SELECT year('2016-07-30'); 2016
dayofmonth function
dayofweek function
day function
hour function
minute function
extract function