-20447 FORMAT STRING format-string IS NOT VALID FOR THE function-name FUNCTION
Explanation
An invalid format string was specified for the function.
- format-string
- The invalid format string. The format might be invalid for one
or more of the following reasons:
- The format string contains unsupported format elements or separator characters.
- The format string does not contain a format element, is the empty string, or is all blanks.
- The length of the format string argument exceeds the maximum allowable length.
- A format element is specified multiple times.
- The format string contains too many format elements.
- The format string contains multiple format elements that represent the same component. For example, the TIMESTAMP_FORMAT function must not specify both YYYY and YY, which are format elements to indicate the year, in the format string.
- A parameter marker was specified for the first argument and the format string includes a time zone format element
- function-name
- The name of the function.
System action
The statement cannot be processed.
Programmer response
Change the format string argument for the function.