Unable to convert date to a particular format

[#1]

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.

[#2 · Accepted solution]

@rafy 

Try this:

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

Cheers,

André

[#3]

Thank you sir. It works.