wie wärs einfach mit

Insert into ...
select ...
TIME(
SUBSTR(DIGITS(TimeNum), 1, 2) || ':' || SUBSTR(DIGITS(TimeNum), 3, 2) ||':'||
SUBSTR(DIGITS(TimeNum), 5, 2)) ...