![]() |
|
The incvasc() function converts a string that conforms to the ANSI SQL standard for an INTERVAL value to an interval value.
You must initialize the interval variable in invvalue with the qualifier that you want this variable to have.
The character string in inbuf can have leading and trailing spaces. However, from the first significant digit to the last, inbuf can only contain characters that are digits and delimiters that are appropriate to the qualifier fields of the interval variable.
If the character string is an empty string, the incvasc() function sets the value in invvalue to null. If the character string is acceptable, the function sets the value in the interval variable and returns zero (0). Otherwise, the function sets the value in the interval value to null.