PHP - Importar fechas de CSV

$query = <<<eof

        LOAD DATA LOCAL INFILE '$file'

         INTO TABLE sustance

         FIELDS TERMINATED BY ','

         LINES TERMINATED BY '\n'

         IGNORE 1 LINES

        (id_sus,name_sus,Casnum_sus,status_sus,Prohi_sus)

eof;

$query = <<<eof

        LOAD DATA LOCAL INFILE '$file'

         INTO TABLE sustance

         FIELDS TERMINATED BY ','

         LINES TERMINATED BY '\n'

         IGNORE 1 LINES

        (id_sus,name_sus,Casnum_sus,status_sus,@var1)

        set Prohi_sus = STR_TO_DATE(@var1, '%d-%m-%y')

eof;