KFAA31227-E

The specified scalar function TIMESTAMPADD is invalid.

• The combination of the data type of the target data and the date/time unit designation is invalid. <SQLSTATE:4278T>

• A value that is outside the specification range is specified in the add value. <SQLSTATE: 4278U>

aa....aa: Cause of the error

• the combination of the data type of the target data and the datetime unit is invalid

  The combination of the data type of the target data and the date/time unit designation is invalid.

• the addition value is outside the valid range

  A value that is outside the specification range is specified in the add value.

  The following shows the combinations of range of numeric data values that can be specified for the date and time units and add value.

  • YEAR: -9,998 to 9,998

  • QUARTER: -39,995 to 39,995

  • MONTH: -119,987 to 119,987

  • DAYOFYEAR: -3,652,058 to 3,652,058

  • DAY: -3,652,058 to 3,652,058

  • WEEK: -521,722 to 521,722

  • HOUR: -87,649,415 to 87,649,415

  • MINUTE: -5,258,964,959 to 5,258,964,959

  • SECOND: -315,537,897,599 to 315,537,897,599

  • MILLISECOND: -315,537,897,599,999 to 315,537,897,599,999

  • MICROSECOND: -315,537,897,599,999,999 to 315,537,897,599,999,999

  • NANOSECOND: -9,223,372,036,854,775,807 to 9,223,372,036,854,775,807

  • PICOSECOND: -9,223,372,036,854,775,807 to 9,223,372,036,854,775,807

bb....bb: Query position number

For details about query position numbers, see 1.5 Query position numbers.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement.