Steps to reproduce this issue

1. Execute a query that returns a date/time datatype that has fractions of seconds. I'm using MSSQL datetime datatype in this example.
2. Export to Excel CSV.
3. Open in Excel. I'm using 2016.

Current behavior

Date/time values are considered strings by Excel.

Expected behavior

Date/time values are considered date/time values by Excel.

Possible solution

Remove fractions of seconds in Excel CSV format OR add an option to do that. In a feature that says "Excel CSV", I'd expect a format that is interpreted correctly by Excel always or by default.

Current workaround

Manually select CONVERT(varchar, columnname, 20) columnname (MSSQL) instead. 20 is the name of the correct format.

Environment

• HeidiSQL version: 5906 (current nightly)
• Database system and version: MSSQL