Skip to main content
rafy
rafy
Gold ⭐️
August 10, 2022
Solved

Unable to convert date to a particular format

Hello, please kindly help. i am trying to convert a datetime(attribute) from one format to the other but it keeps giving me empty value on the attribute:

SCENERIO:
Flowfile is json----->extract date from Json flowfile using Evaluatejsonpath---->format date using Updateattribute

Actual Date: "2022-08-01 00:00:00.0"

Desired date: "01/08/2022 00:00:00.000000"

I have tried to use this on the updateattribute, but it is not working:

${DATE_TIME:toNumber():toDate('yyyy-MM-dd hh:mm:ss.S'):format('dd/MM/yyyy HH:mm:ss.SSSSSS')}

 

Thank you.

araujo
araujoAnswer
Platinum ⭐️⭐️⭐️
August 11, 2022

@rafy 

 

Try this:

${DATE_TIME:toDate('yyyy-MM-dd HH:mm:ss.SSSSSSSSS'):format('dd/MM/yyyy HH:mm:ss.SSSSSS')}

 

Cheers,

André

-- 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.
View in thread

2 replies

araujo
Platinum ⭐️⭐️⭐️
araujoAnswer
Platinum ⭐️⭐️⭐️
August 11, 2022

@rafy 

 

Try this:

${DATE_TIME:toDate('yyyy-MM-dd HH:mm:ss.SSSSSSSSS'):format('dd/MM/yyyy HH:mm:ss.SSSSSS')}

 

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.
rafy
rafyAuthor
Gold ⭐️
August 11, 2022

Thank you sir. It works. 

Translate
Terms & ConditionsAccessibility statement