Product Solutions Support
Try MemSQL

YEAR

Extracts the year from the given datetime.

YEAR ( dateobj )

Arguments

Return Type

Integer

Examples

memsql> select year('2009-02-13');
+--------------------+
| year('2009-02-13') |
+--------------------+
|               2009 |
+--------------------+
Was this article useful?