How to convert String to ZonedDateTime with Field Type Converter

  • 3 December 2021
  • 1 reply
  • 267 views
Sami
Rank
Userlevel 3
  • Sami StreamSets Employee
  • StreamSets Employee
  • 0 replies

Question:

How to convert a string with seven digits ms precision to ZonedDateTime format?

Answer:

Given the following string:  "2020-01-01 02:00:04.1234567 -05:00"

In the Field Type Converter, in the Zoned DateTime Format, choose other Zoned DateTime Format and type yyyy-MM-dd HH🇲🇲ss.SSSSSSS VV

1 reply

Clinton
Rank

Thank you for this info! Would it be possible to convert String representation of timestamp to Epoch (Long representation of time), using Field Type Converter Stage as well?

 

Reply


Terms & Conditions