My requirement is that I have a text field (CHAR) that shows time values in the form HH:MM:SS. I would like extract the hours, minutes and seconds from the text field and convert them all to seconds. I have tried using INSTR, SUBSTRING & LOCATE but have not been able to come up with a solution.
Example Output - 02:00:00 will become 7200 seconds.