Interval() formats a number as a time interval using the format in the system variables in the data load script, or the operating system, or a format string, if supplied.
Intervals may be formatted as a time, as days or as a combination of days, hours, minutes, seconds and fractions of seconds.
Syntax:
Interval(number[, format])
Return data type: dual
Arguments:
| Argument | Description |
|---|---|
| number | The number to be formatted. |
| format | String describing how the resulting interval string is to be formatted. If omitted, the short date format, time format, and decimal separator set in the operating system are used. |