v.24.6Backward Incompatible Changes
New Snowflake ID Conversion Functions Added and Old Functions Deprecated
New functionssnowflakeIDToDateTime,snowflakeIDToDateTime64,dateTimeToSnowflakeID, anddateTime64ToSnowflakeIDwere added. Unlike the existing functionssnowflakeToDateTime,snowflakeToDateTime64,dateTimeToSnowflake, anddateTime64ToSnowflake, the new functions are compatible with functiongenerateSnowflakeID, i.e. they accept the snowflake IDs generated bygenerateSnowflakeIDand produce snowflake IDs of the same type asgenerateSnowflakeID(i.e.UInt64). Furthermore, the new functions default to the UNIX epoch (aka. 1970-01-01), just likegenerateSnowflakeID. If necessary, a different epoch, e.g. Twitter's/X's epoch 2010-11-04 aka. 1288834974657 msec since UNIX epoch, can be passed. The old conversion functions are deprecated and will be removed after a transition period: to use them regardless, enable settingallow_deprecated_snowflake_conversion_functions. #64948 (Robert Schulze).