Date Data Type Conversion [closed]

asked 2019-03-06 15:12:00 -0500

srinath_222 gravatar image

updated 2019-03-06 15:17:51 -0500


I have a requirement to convert date and datetime data types from relational source to String data type and load to ElasticSearch destination.

For Data type conversion, I am using Field Type Converter processor to convert the types.

It is converting correctly for few dates but for few dates it is giving +1 day. Please find attached screenshots for reference.

Please suggest me if this is a defect or an alternative approach to proceed.image description

edit retag flag offensive reopen merge delete

Closed for the following reason question is off-topic or not relevant by srinath_222
close date 2019-03-07 13:01:47.685660


Did you check the results after running the pipeline? Is it still the same?

Maithri gravatar imageMaithri ( 2019-03-07 05:05:57 -0500 )edit

I checked the data in the target after running the pipeline, it is +1 day for few columns. For few columns, it is same as source.

srinath_222 gravatar imagesrinath_222 ( 2019-03-07 08:24:30 -0500 )edit