JDBC receiver conversion out-of-range value error

[harish_babu5]

Hi

I am doing an ECC to JDBC scenario and I am getting this error.

"The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value."

The payload looks fine to me. We are sending date to MS SQL Date is sent in this format 2015-07-29 00.00.00. We have another interface with just three fields. It's working fine.

What possibly could be the reason? I am getting error in another JDBC intrface also

Regards

[ridvan_polat · Accepted solution]

Hi Harish,

Datetime formats are depends on logged in user's language, you should use a safe, language-independent format.

In SQL Server, that's the ISO-8601 format, and it supports basically two safe formats for DATETIME that always work - regardless of your language, regional and dateformat settings:

YYYYMMDD                           (e.g. 20121231  for 31st of December 2012)  if you need date only

YYYY-MM-DDTHH:mm:ss     (e.g. 2012-12-31T21:05:00 for 31st of December 2012, 9:05pm)

Regards,

Ridvan Polat

[harish_babu5 · Accepted solution]

The database table did something

It was not error from PI side and now my interface is working

Regards

Harish Babu

[Former Member]

MSSQL date format doesn't looks correct. try sending the value as MM/dd/yyyy format.