TO_DSINTERVAL

TO_DSINTERVAL converts a text expression to an INTERVAL DAY TO SECOND data type.

Return Value

INTERVAL DAY TO SECOND

Syntax

TO_DSINTERVAL(char)

Arguments

char is a text expression to be converted.

Example

TO_DSINTERVAL('360 12:45:49') returns the value +360 12:45:49.000000.