Hi.
I want to insert data from a .csv file into a mySQL table, but there's a field "Date" in my .csv file which is in format 'DD/MM/YYYY' and in order to be inserted into the table it should be in format 'YYYY-MM-DD'.
Also, I have the same issue with another field called "Time" which in my .csv has format 'HH:MM' and in order to be insterted into the table it should be like 'HH:MM:SS' (where in my case SS will be 00 by default, as there isn't provided a value in the .csv file for seconds).
Is it possible to modify the input of "Date" and "Time" fields provided from .csv file, before inserting them into the table, using HeidiSQL?
Thanks in advance.