You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

YEAR

Extracts the year from the given datetime.

Syntax

YEAR ( dateobj )

Arguments

  • dateobj: a valid date, datetime, or parsable date string.

Return Type

Integer

Examples

memsql> select year('2009-02-13');
+--------------------+
| year('2009-02-13') |
+--------------------+
|               2009 |
+--------------------+

Related Topics