Created on 08-09-2019 03:02 AM - edited 08-17-2019 04:18 PM
Is there some way to convert "file.creationtime" format to timestamp format?
Like below:
to
Created 08-12-2019 01:26 AM
Try with adding new attribute in UpdateAttribute processor as
epochtime
${file.creationTime:toDate("yyyy-MM-dd'T'HH:mm:ss+0000"):toNumber()}
Then nifi will match the format and convert to epoch time.
Created 11-27-2023 12:40 AM
${file.creationTime:toDate("yyyy-MM-dd'T'HH:mm:ss+0000"):toNumber()} = not working
Created 11-27-2023 08:10 AM
Your original example had everything at +0000 but the error has +0700 so perhaps change the pattern to
yyyy-MM-dd'T'HH:mm:ssZ