Hey 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
It looks like an epoch time, but not the standard Unix one. Where is this coming from?
It 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
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
Ahh, awesome. thank you @Hans van der Maarel