Problems importing excel to database PHPMYADMIN

-2

Good morning, I'm trying to import a .csv document that contains 4 columns which are name, shift, start_date, end_date, the problem I have is that when I import the file the name and shift information if it appears in the database but the dates are saved as pergo, and check the excel side and the date has the correct format, I could be guided which part I am omitting or which is the error for which the date is not saved correctly ?

    
asked by Xavi 18.12.2018 в 17:10
source

1 answer

0

Edit your excel file, mysql requires the format 'YYYY-MM-DD' for a DATE and the format 'YYYY-MM-DD HH: ii: ss' for DATETIME.

    
answered by 20.12.2018 в 00:08