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
zentnerfabian wrote:
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 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:
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.