I am working with a table that stores times in military format as varchar(6). I need to display and calculate durations.

How can I show for example 1015 as 10:15 and calculate 1015 - 30 getting 09:45 ?

I didn't find any conversion functions yet.

Thanks in advance.

Conversion functions and to_date.