+5Hey everybody,
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:
+59It looks like an epoch time, but not the standard Unix one. Where is this coming from?
+5It looks like an epoch time, but not the standard Unix one. Where is this coming from?
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
+59this 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:
+5this is from the NGA, so data I downloaded has this timestamp. The Unix Timestamp is just 3 digits less.
Timestamp: 746841600000
Unix Timestamp: 746841600
Ahh, awesome. thank you @Hans van der Maarel
