M
M
mantovpinets2017-08-23 15:49:44
MySQL
mantovpinets, 2017-08-23 15:49:44

Can I use the date format dd.mm.yyyy when importing a database?

Good day to all.
There was a following problem. There is a csv file with data (about 200K lines) that needs to be imported into the mysql database. The data has a "Date" field and data in it in the format dd.mm.yyyy. Can I import data with this date format and then change the data type to Date? Or do I need to somehow alter the date format in the CSV file?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question