Built-in Functions → year
year() is a scalar date function that returns the year component from a date or timestamp value. If the argument is a string, the format should be "yyyy-MM-dd HH:mm:ss".
Syntax
year(date exp)
The following table illustrates the year() parameter:
| Parameter | Description |
|---|---|
| date exp | an expression evaluating to timestamp |
Returns
int
Example
year(timestamp("2001-12-24 23:55:12.000"))
The result is 2001