Solved

how to convert sting to datetime offset

  • 16 February 2022
  • 2 replies
  • 225 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

icon

Best answer by xavi 16 February 2022, 18:20

View original

2 replies

Userlevel 5
Badge

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

Hi @akanshajain6793,

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

 

Reply