question Re: Apache Nifi - DateTime 0000-00-00 00:00:00 cannot be converted to TimeStamp in Support Questions

Apache Nifi - DateTime 0000-00-00 00:00:00 cannot be converted to TimeStamp

J0sh — Fri, 22 Apr 2022 01:54:42 GMT

I have a JSON data with DateTime as 0000-00-00 00:00:00 & it is not been accepted in SQL

Please Support to resolve this issue for me

Re: Apache Nifi - DateTime 0000-00-00 00:00:00 cannot be converted to TimeStamp

araujo — Fri, 22 Apr 2022 04:20:10 GMT

You can add a ReplaceText doing a literal translation of 0000-00-00 00:00:00 with a valid date/time (e.g. 1970-01-01 00:00:00)

Cheers,

André

Re: Apache Nifi - DateTime 0000-00-00 00:00:00 cannot be converted to TimeStamp

J0sh — Fri, 22 Apr 2022 16:11:59 GMT

I Still get the same error & my SQl.args.21.value has multiple wrong timeStamp values (eg: 2000-00-17)
I can avoid or remove that column from the flowfile

Re: Apache Nifi - DateTime 0000-00-00 00:00:00 cannot be converted to TimeStamp

J0sh — Fri, 22 Apr 2022 16:45:28 GMT

https://community.cloudera.com/t5/Support-Questions/PUTSQL-which-cannot-be-converted-to-a-timestamp/m-p/292827

This is the solution for my query thanks