Dates values displayed 0000-00-00 I have imported a csv file into my database created in phpmyadmin using sql. 


  Server version: 5.6.37 - MySQL Community Server (GPL 


I have a column for dates which has a datatype of date. The data displayed on webpage for all the dates are as 0000-00-00. However in the csv file the format is 12/2/2016. Could any one please help how could I resolve this issue?
Use user-defined variable for to convert the date value from dd\mm\YYYY format to the date/datetime datatype value during import:

LOAD DATA INFILE 
....
(field1, field2, ..., @date, ...)
SET datefield = STR_TO_DATE(@date, '%d\/%m\/%Y');