I need to change format of a date column from D-M-Y to Y-M-D in excel – Phpmyadmin
I was trying to import a CSV file to my phpmyadmin. Then my date field had values as 0000-00-00 since both date formats were different. I changed the CSV date-format to the format in the database. I have 5000+ data…