Support Questions
Find answers, ask questions, and share your expertise

PUTSQL which cannot be converted to a timestamp

Solved Go to solution

PUTSQL which cannot be converted to a timestamp

Explorer

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 

2020-03-30 14_47_52-Inbox (2,675).png

1 ACCEPTED SOLUTION

Accepted Solutions

Re: PUTSQL which cannot be converted to a timestamp

Explorer

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 ?

View solution in original post

3 REPLIES 3

Re: PUTSQL which cannot be converted to a timestamp

Explorer

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 ?

View solution in original post

Re: PUTSQL which cannot be converted to a timestamp

@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

Explorer

Thanks Steven