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​

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

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