I have a huge csv file with the attribute field "modify_date" and the date is in "Timestamp" - format (so for example 746841600000).
I would like to have it in ISO Date format (1993-09-01 02:00:00).
Is there any transformer which can do that? The Date/Time Converter is not able to do that...
Thanks in advance.
Cheers,
Fabian
Best answer by redgeographics
this is from the NGA, so data I downloaded has this timestamp. The Unix Timestamp is just 3 digits less.
Timestamp: 746841600000
Unix Timestamp: 746841600
Ah, in that case just use an AttributeCreator to create a new attribute, filling it with the original date/time value divided by 1000. Then the DateTimeConverter:
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.
this is from the NGA, so data I downloaded has this timestamp. The Unix Timestamp is just 3 digits less.
Timestamp: 746841600000
Unix Timestamp: 746841600
Ah, in that case just use an AttributeCreator to create a new attribute, filling it with the original date/time value divided by 1000. Then the DateTimeConverter: