Option to have different date formats when importing csv files
Brought to you by:
ansgarbecker
Menu
▾
▴
#3159 Option to have different date formats when importing csv files
CantFix
nobody
None
Default
Enhancement
2013-05-24
2013-04-09
Anonymous
No
Originally created by: rwgiese...@gmail.com
What is the problem that needs to be solved (required)?
The import file as a date "m/d/yyyy 00:00" and it does not import. I have to manually open the file in Excel and format the datetime field to be "yyyy/m/d 00:00" and then the import does not error.
What is the idea in abstract terms (optional)?
To be able to import any datetime format.
What is a practical way to implement this idea (optional)?
Provide a drop down with different date formats of the date or dates within the file. Then convert the file date to the correct format
Nice application. Thanks for allowing to submit feedback.
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
I'm afraid MySQL's LOAD command does not allow other date formats then those used and allowed by MySQL. There is also no check at all for column data types, so HeidiSQL does not even know which of the fields in your csv file is a date/time value.
Status: CantFix