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 [ 'nlsparam' ])

Arguments

char is a text expression to be converted.

nlsparam is a setting for the NLS_NUMERIC_CHARACTERS parameter. This argument can have the form:

NLS_NUMERIC_CHARACTERS = "dg" 

where d is the decimal character, and g is the group separator. Neither character can be a space.

Example

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

Copyright © 2003, 2007, Oracle. All rights reserved.