Convert date time to 24 hour format in NiFi

janvit04 — Wed, 16 Aug 2023 10:22:56 GMT

I am trying to convert the following date format -> 8/6/2023 12:46 am to this format -> 2023-08-06 00:46:00.

I want to do this using NiFi. I have tried using the UpdateRecod processor for the same and used toDate() and format() for the above conversion. But it didn't give the desired results.

How can I achieve this using NiFi?

Re: Convert date time to 24 hour format in NiFi

steven-matison — Wed, 16 Aug 2023 13:20:59 GMT

@janvit04 The pattern you need is this:

${input_date:toDate("MM/dd/yyyy hh:mm:ss"):format("yyyy-MM-dd HH:mm:ss")}

I did this in a test which you can find here. In this example I have UpdateAttribute with an input attribute called input_date and its string value is "8/6/2023 12:46 am". In next UpdateAttribute i do the toDate and format. With this setup you may need to modify the format in toDate function to match your input string until it gets right format. For example I thought it should be m/d/yyyy but i got right output using MM/dd/yyyy.

question Convert date time to 24 hour format in NiFi in Support Questions

Convert date time to 24 hour format in NiFi

Re: Convert date time to 24 hour format in NiFi