Skip to main content
J0sh
Gold ⭐️
Apr 22, 2022 1:54 AM UTC
Solved

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

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

J0sh_Apache Nifi.png

 

J0sh
J0shAnswer
Gold ⭐️
Apr 22, 2022 4:45 PM UTC

3 replies

araujo
Platinum ⭐️⭐️⭐️
Platinum ⭐️⭐️⭐️
Apr 22, 2022 4:20 AM UTC

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

 

Translate
-- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.
J0sh
J0shAuthor
Gold ⭐️
Apr 22, 2022 4:12 PM UTC

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

J0sh_0-1650643789246.png

 

Translate
J0sh
J0shAuthorAnswer
Gold ⭐️
Apr 22, 2022 4:45 PM UTC