Skip to main content

TO_YYYYMM

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

Syntax​

to_yyyymm( <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 to_yyyymm(to_date(18875));
+-------------------------+
| to_yyyymm(to_date(18875)) |
+-------------------------+
|                  202109 |
+-------------------------+