FunctionsDate & Time

to_yyyymmd_dhhmmss

Converts a date/time value to a sortable date-time key in the legacy YYYYMMD_DHHMMSS family. In V1 this variant returns the same numeric layout as to_yyyymmddhhmmss.

to_yyyymmd_dhhmmss(…) → Int64

Kind · scalar

Converts a date/time value to a sortable date-time key in the legacy YYYYMMD_DHHMMSS family. In V1 this variant returns the same numeric layout as to_yyyymmddhhmmss.

Part of the Date & Time family.

to_yyyymm

Converts a date/time value to an integer key in YYYYMM form. This is useful for building sortable time keys without string formatting.

to_yyyymmdd

Converts a date/time value to an integer key in YYYYMMDD form. This is useful for building sortable time keys without string formatting.