Background documentation-6016: Duplicate format code Locate this document in the navigation structure

 

Explanation

  1. A format element was specified several times in the function TO_DATE.

  2. In the format specification of the TO_DATE function, format elements were specified which must not occur together. For example, day of year (DDD) and Julian calendar date must not occur together. There must not be several specifications denoting the year, e.g. YYYY and YY, or the month, e.g. MM and MONTH.

User Response

  1. Remove the format elements that are specified too often.

  2. Remove one of the format elements that cannot occur together.