Start of change

-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.

SQLSTATE

22007
End of change