to_hhmmss — convert an interval into a string with format
"HH:MM:SS". E.g. 1 day 02:03:04
becomes 26:03:04.
TEXT
to_hhmmss
(
|
this_interval); |
INTERVAL
this_interval
;Returns a text string, the interval converted into HH:MM:SS format.
This function is used by the CURATED_TEMPS view to standardize the format of the Timespan and Time_Missed columns.
Intervals that include time units of variable length like months and years will yield unpredictable results.