Hi,
I have two strings in format 'hh:mi:ss', I want subtract those two strings in the analysis.
First I tried to convert the strings with cast to a timestamp, but I get an error. Then I think maybe I must create a function which makes from this format numbers, subtract them and then convert it back to format hh:mi:ss.
But I think that is not a good solution, so my question is: Can I substract two strings
Example:
String 1 - String 2 = Result
02:38:16 - 00:07:15 = 02:31:01
With regards,
Ed