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.
Solved
Is it possible convert milliseconds to %Y-%m-%d %H:%M:%S?
+8- Contributor
- 15 replies
Best answer by david_r
You can divide the milliseconds by 1000 and send it into the DateTimeConverter with something like:
Result:
1663767945000 -> 2022-09-21 13:45:45
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 8392 replies
- Best Answer
You can divide the milliseconds by 1000 and send it into the DateTimeConverter with something like:
Result:
1663767945000 -> 2022-09-21 13:45:45
+8- Contributor
- 15 replies
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.
+8- Contributor
- 15 replies
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.
Thanks a lot!
Regards.