Skip to main content

TOYEAR

Converts a date or date with time to a UInt16 number containing the year number (AD).

Syntax​

TOYEAR( <expr> )

Arguments​

ArgumentsDescription
<expr>date/datetime

Return Type​

A UInt16 date type value

Examples​

SELECT toyear(now());
+---------------+
| toyear(now()) |
+---------------+
|          2022 |
+---------------+

SELECT toyear(to_datetime(1));
+-----------------------+
| toyear(to_datetime(1)) |
+-----------------------+
|                  1970 |
+-----------------------+