Importing data with dates AND times spearately

[Karl Delargy]

Hi,

I'm trying to import some data sets (.csv) using MySQL workbench. When designing the model, it will only let me select DATETIME as the datatype for importing the date and the time. My data has date and time separately, and the dates are saved DD/MM/YYYY instead of DD-MM-YYYY, and the times are saved HH:MM instead of HH:MM:SS. I cannot change these as the datasets are too big.

Is there any way which these can be imported? What is the format for DATE() or TIME() on their own? Because no records are being imported when i use DATE() or TIME() as the datatype.

Thanksssssss