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

Cannot convert to timestamp error using putsql processor NiFi 1.3.0

Cannot convert to timestamp error using putsql processor NiFi 1.3.0

Hello,

I'm working for a data flow POC form one mysql database to other for that i'm using ConvertJsonToSql(Relationships sql and original)------>UpdateAttribute(Property:sql.args.n.value and value:${sql.args.n.value:format("yyyy-MM-dd HH:mm:ss.SSS")}This answer)-------->PutSQL. But still i'm facing the same issue any suggestions are welcome and appreciated.

Thanks

Rakesh.

2 REPLIES 2

Re: Cannot convert to timestamp error using putsql processor NiFi 1.3.0

I got answer for this In updateattribute processor property: sql.args.27.value and value :${sql.args.27.value:toDate("EEE MMM dd HH:mm:ss z yyyy"):toNumber():format("yyyy-MM-dd HH:mm:ss.SSS")}

Re: Cannot convert to timestamp error using putsql processor NiFi 1.3.0

Expert Contributor

@rakesh chow

Thank you for sharing your solution. I was facing the same problem and solved it with your information! Great!