15.3.4 to_dsinterval(value1)

Function converts a string in format 'DD HH:MM:SS' into a INTERVAL DAY TO SECOND data type. The DD part indicates the number of days between 0 to 99. The HH:MM:SS part indicates the number of hours, minutes and seconds in the interval from 0:0:0 to 23:59:59.999999. The second part can accept upto 6 decimal places.

Input value can be one of the following types: text.

Returned value will be of type interval.

Function Result

to_dsinterval("02 23:34:12")

2 dd 23hr 34mm 12 sec