FunctionsDate & Time

to_yyyymmddhhmmss

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

to_yyyymmddhhmmss(…) → Int64

Kind · scalar

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

Part of the Date & Time family.

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.

today

Returns the current date according to the query execution context (typically the session or server time zone). Useful for date-based filtering and partition pruning without constructing a timestamp.