Question

how to get data time format from mongodb to mysql .

  • 4 April 2023
  • 1 reply
  • 14 views
lakshmi_narayanan_t
Rank
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

AkshayJadhav
Rank
Userlevel 4
Badge

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.

-AkshayJ

Reply


Terms & Conditions