|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
TO_DSINTERVAL converts a character string of
NVARCHAR2 datatype to an
charis the character string to be converted.
nlsparamyou can specify in this function is
NLS_NUMERIC_CHARACTERS. This argument can have the form:
g represent the decimal character and group separator respectively.
The following example selects from the
employees table the employees who had worked for the company for at least 100 days on January 1, 1990: