Skip to main content
MPraveen
MPraveen
Gold ⭐️
March 30, 2020
Solved

PUTSQL which cannot be converted to a timestamp

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

MPraveen
MPraveenAnswer
Gold ⭐️
March 30, 2020

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 in thread

3 replies

MPraveen
MPraveenAuthorAnswer
Gold ⭐️
March 30, 2020

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 ?

Translate
    stevenmatison
    stevenmatison
    Platinum ⭐️⭐️
    March 30, 2020

    @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!!

     

    Translate
    MPraveen
    MPraveenAuthor
    Gold ⭐️
    March 31, 2020

    Thanks Steven

    Translate
    Terms & ConditionsAccessibility statement