Skip to main content
Solved

how to convert sting to datetime offset

  • February 16, 2022
  • 2 replies
  • 236 views

how i can convert below string date format to date time offset format and load into EDW

 

2020-10-05 04:52:48455-06:00 to

2020-10-05 04:52:48.455-06:00

Best answer by xavi

Hi @akanshajain6793,

You can use Field Type Converter stage in datacollector. Check this link which gives some details on how to do it:

 

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

2 replies

Drew Kreiger
Rock star
Forum|alt.badge.img
  • Senior Community Builder at StreamSets
  • 95 replies
  • February 16, 2022

@akanshajain6793 Welcome! Moving your question to the “Got a Question?” Category. 


xavi
StreamSets Employee
  • StreamSets Employee
  • 1 reply
  • Answer
  • February 16, 2022

Hi @akanshajain6793,

You can use Field Type Converter stage in datacollector. Check this link which gives some details on how to do it:

 


Reply