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

[#1]

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

 

[#2]

@J0sh ,

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é

[#3]

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

[#4 · Accepted solution]

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

This is the solution for my query thanks