Skip to main content

How to convert String to ZonedDateTime with Field Type Converter

  • December 3, 2021
  • 1 reply
  • 298 views
Sami
StreamSets Employee
  • SamiStreamSets Employee
  • StreamSets Employee

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

Did this topic help you find an answer to your question?

1 reply

Clinton
Fan
  • ClintonFan
  • Fan
  • 2 replies
  • December 15, 2021

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