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

SELECT to_date(18875);
+---------------+
| to_date(18875) |
+---------------+
| 2021-09-05    |
+---------------+

SELECT toYYYYMM(to_date(18875));
+-------------------------+
| toYYYYMM(to_date(18875)) |
+-------------------------+
|                  202109 |
+-------------------------+