Skip to main content
Solved

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

  • January 12, 2023
  • 4 replies
  • 163 views

zentnerfabian
Contributor
Forum|alt.badge.img+5

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

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:

Schermafbeelding 2023-01-12 130616

View original
Did this help you find an answer to your question?

4 replies

redgeographics
Celebrity
Forum|alt.badge.img+49

It looks like an epoch time, but not the standard Unix one. Where is this coming from?


zentnerfabian
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • January 12, 2023
redgeographics wrote:

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


redgeographics
Celebrity
Forum|alt.badge.img+49
  • Celebrity
  • Best Answer
  • January 12, 2023
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:

Schermafbeelding 2023-01-12 130616


zentnerfabian
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • January 12, 2023
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

Ahh, awesome. thank you @Hans van der Maarel​ 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings