Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to convert string to DateTime correctly using Field Type Converter?

Hi,

I am trying to convert input string data to output DATETIME data in StreamSets using Field Type Converter.

I am using

Date Format: Other

Other Date Format: MMddyyyy HH:mm:ss

When I run the preview,

the string 01312019 00:00:00 gets converted to datetime Jan 31, 2019 1:00:00 AM and not Jan 31, 2019 12:00:00 AM

What is the reason behind this discrepancy and how can this be avoided ?

Thanks in advance for your help.