Bug #104806 Date Import format not specified
Submitted: 2 Sep 2021 9:00 Modified: 29 Sep 2021 12:40
Reporter: John King Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench Severity:S7 (Test Cases)
Version:8.0.23 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[2 Sep 2021 9:00] John King
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Johannes\AppData\Roaming\MySQL\Workbench\log\wb.log]

During import it is not possible to set the date format. Only when a new table is created the datetime format can be specified.

How to repeat:
Create a table with datetime fields

attempt to import a text file (csv) with a different date format (dd.mm.yyyy)

Suggested fix:
Allow selection of the datemask just like the one creating a new table.
[2 Sep 2021 9:01] John King

Attachment: wb.log (application/octet-stream, text), 55.34 KiB.

[29 Sep 2021 12:40] MySQL Verification Team
Hello John King,

Thank you for the reasonable feature request!

Ashwini Patil