Re: Importing data with dates AND times spearately

[Barry Galbraith]

Date and Time formats
http://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html

Seeing as you have dates as DD/MM/YY you can import and convdert these on the fly with STR_TO_DATE() by using a format string to tell MySQL what the format of your date is.
http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_str-to-date

mysql> select str_to_date('19/07/2016', '%d/%m/%Y');
+---------------------------------------+
| str_to_date('19/07/2016', '%d/%m/%Y') |
+---------------------------------------+
| 2016-07-19                            |
+---------------------------------------+
1 row in set (0.00 sec)

Good luck,
Barry.