Representation of converted DateTime to string changed after upgrading from SDC 2.7.1 to 3.7.1

asked 2019-06-12 08:15:58 -0500

anonymous user


updated 2019-06-12 10:09:13 -0500

jeff gravatar image

I have upgraded from Streamsets SDC 2.7.1 to 3.7.1. When I ran the same pipeline on the new version, I noticed a surprising change in the behavior of field conversions. First, let me add that I convert DateTime fields of the source to String in the pipeline. In the 2.7.1 version, the representation of the converted dateTime was like: 1950-07-03 01:00:00. However, in the new version, the representation changed to this format: Mon Jul 03 01:00:00 GMT 1950.

I need the old format. Does anyone know how I can keep the old representation of the conversion in the new version of Streamsets SDC?

edit retag flag offensive close merge delete


How were you specifying the conversion? Was it using the field type converter, and without providing a date format? Can you please share a screenshot of the stage configuration, and also the preview screen showing before/after?

jeff gravatar imagejeff ( 2019-06-12 10:08:37 -0500 )edit