Home / Blog / Streamsets Data Collector DATETIME type in Field Converter
Angel's picture
Angel Alvarado R.
CEO and Data engineer.
23 Jan 2017
Streamsets
Data Collector DATETIME type in Field Converter

A little gotcha using SCD and DATETIME type

Body: 

Details about DATETIME type in the Field Converter:

 

I noticed that the output while previewing a DateTime conversion seems to change the actual date. E.g. from string "07/19/2016" to DateTime Jul 18, 2016 4:00:00 PM 

While this seems like a bug, it's not. SDC uses the browser's timezone to display dates in the UI. Moodify Streamsets Data Collector to use a specific time zone. Go to HELP in the top right corner and click on Settings.

After modifying this setting you'll see 


References

https://groups.google.com/a/streamsets.com/forum/#!topic/sdc-user/S3bfsrMOYJk

https://groups.google.com/a/streamsets.com/forum/#!topic/sdc-user/xsAvMdf0EIM

https://streamsets.com/documentation/datacollector/latest/help/