v.20.11New Feature

Add function formatReadableTimeDelta for human-readable time deltas

Add function formatReadableTimeDelta that format time delta to human readable string ... #15497 (Filipe Caixeta).
Introduces the formatReadableTimeDelta function to convert time intervals into human-readable string formats.

Why it matters

This feature allows users to easily interpret and display time durations by formatting raw time delta values into more understandable and readable text representations, improving clarity in time-based data analysis and reporting.

How to use it

Use the function formatReadableTimeDelta in your queries by passing a time interval value. For example:
SELECT formatReadableTimeDelta(toIntervalSecond(3661))
will return a human-readable string representing the time delta.