Skip to main content

toYYYYMM

Converts a date or date with time to a UInt32 number containing the year and month number.

Syntax​

toYYYYMM(expr)

Return Type​

UInt32, returns in YYYYMM format.

Examples​

mysql> select toDate(18875);
+---------------+
| toDate(18875) |
+---------------+
| 2021-09-05    |
+---------------+

mysql> select toYYYYMM(toDate(18875));
+-------------------------+
| toYYYYMM(toDate(18875)) |
+-------------------------+
|                  202109 |
+-------------------------+

mysql> select toTypeName(toYYYYMM(toDate(18875)));
+-------------------------------------+
| toTypeName(toYYYYMM(toDate(18875))) |
+-------------------------------------+
| UInt32                              |
+-------------------------------------+