how to get data time format from mongodb to mysql .

  • 4 April 2023
  • 1 reply

Userlevel 2

the json data in mongodb had  a date format as a  timestamp in value  but during  process only date shown not timestamp show. how to fix 

below is my mongodb data:-

 but  inside of data updatedAt column has timestamp value but in streamsets not shown.

how to get timestamp value from mongodb origin.

1 reply

Userlevel 4

Hello @lakshmi_narayanan_t - Thank you for reaching out to the StreamSets Platform.
Could you please try adding the Field Type converter and select the proper data format for the date field?


Let us know how it goes.