IBM Support

Arithmetic overflow error converting expression to data type datetime *|* -B0148F916D8794E185257918007DF482- *|*

Question & Answer


Question

Arithmetic overflow error converting expression to data type datetime *|* -B0148F916D8794E185257918007DF482- *|*

Answer

Technote (troubleshooting)


Problem(Abstract)

Arithmetic overflow error converting expression to data type datetime

Symptom

LWJDBC adapter fails when updating a column with a time that has an hour value of 24.

The business process was using the "TimestampUtilService" with this parameter yy/MM/dd kk:mm:ss:SSS

The kk value generates the hour in the range 1-24.

This was causing the error in the LWJDBC adapter when updating an external SQL database.

Error Message

8115: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Arithmetic overflow error converting expression to data type datetime


Resolving the problem

Solution

Replace this yy/MM/dd kk:mm:ss:SSS with yy/MM/dd HH:mm:ss:SSS

HH will generate an hour in the range 00 to 23.

Cross reference information
SegmentProductComponentPlatformVersionEdition
CommerceSterling B2B IntegratorAdapters

Historical Number

TRB2400

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
12 October 2021

UID

ibm10767981

Page Feedback