question PUTSQL which cannot be converted to a timestamp in Support Questions

PUTSQL which cannot be converted to a timestamp

MPraveen — Mon, 30 Mar 2020 05:59:08 GMT

I am facing an issue - in PutSQL

I am sending a date value from XML-JSON->oracle table.

EvaluateJSOn ->RouteAttributes->AttributeJson->ConvertJsontoSQL -> UpdateAttrubites->PutSQL is my flow.

But it is failing always with

Re: PUTSQL which cannot be converted to a timestamp

MPraveen — Mon, 30 Mar 2020 10:32:20 GMT

I resolved the issue(${sql.args.1.value:toDate("yyyy-MM-dd"):toNumber()}).. But I dont understand why we need toNumber() here. Any body have answer to this ?

Re: PUTSQL which cannot be converted to a timestamp

stevenmatison — Mon, 30 Mar 2020 12:59:19 GMT

@MPraveen Hello friend!

I dont your sql schema but the error is wanting the real time version of the data (without the /).

Glad you were able to solve it. Accept your own answer and get a solution credit!!

Re: PUTSQL which cannot be converted to a timestamp

MPraveen — Tue, 31 Mar 2020 02:51:24 GMT

Thanks Steven