Update day to second interval column in selection from time gaps table by parsing strings containing time differences using REGEXP_SUBSTR

(Lucas Jellema) An apparently trivial challenge that still took me bit longer than expected. What is the situation: I have a table with two columns (of interest). One is a column called gap, with values like these:

Read More - Register for Free Membership