Is it possible convert milliseconds to %Y-%m-%d %H:%M:%S?

How I can convert milliseconds (for example: 1663767945000) to %Y-%m-%d %H:%M:%S ?

I tried with a DataTimeConverter transformer but it doesn't detect the input format.

Any ideas?

Thank you.

Page 1 / 1

You can divide the milliseconds by 1000 and send it into the DateTimeConverter with something like:

Result:

1663767945000 -> 2022-09-21 13:45:45

Hi @david_r , thank you for your quick answer!

Have you tried running your example? I did the same but the DateTimeConverter reject the execution.

milliseconts with datetimeconverter

Hi @david_r again, sorry, it was my fault.

I don't know why the dateTimeConverter set the Datetime Attibutes as "@Value...". Now it is working.

Capture2

Thanks a lot!

Regards.

Hi @david_r again, sorry, it was my fault.

I don't know why the dateTimeConverter set the Datetime Attibutes as "@Value...". Now it is working.

Capture2

Thanks a lot!

Regards.

Good to hear. The @Value()-thing is due to a (very annoying) bug, I believe it's been fixed in later versions.

Sign up