Solved

Is there any chance to convert Timestamp Date format into an ISO Date format?

  • 12 January 2023
  • 4 replies
  • 22 views

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

icon

Best answer by redgeographics 12 January 2023, 13:07

View original

4 replies

Userlevel 4
Badge +25

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

Userlevel 4
Badge +25

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:

Schermafbeelding 2023-01-12 130616

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​ 

Reply