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> )

Arguments​

ArgumentsDescription
<expr>date/datetime

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 |
+-------------------------+