The Microsoft SQL Server Extractor will be updated to use a new driver on October 1, 2018.
This update may effect the format of datetime columns if you are using the advanced query option in your configuration.
Standard configurations (not advanced queries) will not have any change to their output.
The old driver exports datetime columns in the format `yyyy-mm-dd hh:mm:ss` however the new driver includes milliseconds when outputting datetime values `yyyy-mm-dd hh:mm:ss.ms`.
There are 2 options to mitigate this change:
1) Recommended: Switch the configuration to select the tables and columns that you need and not use an advanced query.
2) Convert the datetime output column in the SQL query, ex: CONVERT(DATETIME2(0), my_column)
If you have any concerns or questions regarding this update please contact us using the support button in your Keboola Connection project.
Thank you