Skip to main content
Question

how to get data time format from mongodb to mysql .

  • April 4, 2023
  • 1 reply
  • 36 views
lakshmi_narayanan_t
Discovered Fame

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
StreamSets Employee
Forum|alt.badge.img
  • AkshayJadhavStreamSets Employee
  • StreamSets Employee
  • 101 replies
  • April 4, 2023

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


Terms & ConditionsAccessibility statement