Previous Topic: -277 - aaaa RECEIVED UNKNOWN DURATION TYPENext Topic: -279 - INVALID DATE TABLE INDEX (xxx)


-278 - INVALID PREC(xxx) OR SCALE(zzz) FOR DECIMAL DATATYPE

Explanation

The number you have specified as part of a labeled duration is not of the correct precision and/or scale. The scale must be zero, and the precision must be either 6 (for HOURS, MINUTES or SECONDS) or 8 (for YEARS, MONTHS, or DAYS).

The SQLSTATE that equates to this SQL return code is 42815.

User Response

Correct the number that is part of the labeled duration.