- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
PUTSQL which cannot be converted to a timestamp
- Labels:
-
Apache NiFi
Created on 03-29-2020 09:50 PM - last edited on 03-29-2020 10:59 PM by VidyaSargur
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 03-30-2020 03:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?
Created 03-30-2020 03:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?
Created 03-30-2020 05:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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!!
Created 03-30-2020 07:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Steven