I am storing the dates as dates. I did look up the links, thanks for those, @roboticus however, when I run the code by adding @var into my LOAD statement,

LOAD DATA LOCAL INFILE '$fname' INTO TABLE $tname FIELDS TERMINATED BY
+ ',' LINES TERMINATED BY '\r\n' (trade_date,....,@var) SET trade_date
+ = str_to_date(@var, '%d/%m/%Y');
[download]

I get the following error:

Global symbol "@var" requires explicit package name at process.pl line
+ 37.
Execution of process.pl aborted due to compilation errors.
[download]