TO_YYYYMMDDHH

Formats a given date or timestamp into a string representation in the format "YYYYMMDDHH" (Year, Month, Day, Hour).

Syntax

TO_YYYYMMDDHH(<expr>)

Arguments	Description
`<expr>`	date/datetime

Returns an unsigned 64-bit integer (UInt64) in the format "YYYYMMDDHH".

SELECT to_yyyymmddhh(to_datetime(1630833797000000))
----
2021090509


SELECT to_yyyymmddhh(to_date(18875))
----
2021090500

Low-cost

Fast Analytics

Easy Data Ingestion

Elastic Scaling