CRE ATE   TABLE `temp` (
  `id` int(10) UNSIGNED NOT NULL,
  `t_date` char(10) NOT NULL,
  `t_time` time NOT NULL,
  `t_price` decimal(6,2) UNSIGNED NOT NULL,
  `t_val` int(11) NOT NULL,
  `t_op` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

CRE ATE   TABLE `tick` (
  `id` int(10) UNSIGNED NOT NULL,
  `t_d` date NOT NULL,
  `t_t` time NOT NULL,
  `t_p` decimal(6,2) UNSIGNED NOT NULL,
  `t_v` int(10) UNSIGNED NOT NULL,
  `t_op` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

CREATE TRIGGER `temp` BEFORE INSERT ON `temp`
 FOR EACH ROW BEGIN
INS ERT IN TO tick VALUES(NEW.id, STR_TO_DATE(NEW.t_date,'%d.%m.%Y'), NEW.t_time, NEW.t_price, NEW.t_val, NEW.t_op);
END

CREATE TRIGGER `trig` BEFORE INSERT ON `temp`
 FOR EACH ROW BEGIN
INS ERT IN TO ticks (`tick_date`,`tick_time`,`tick_price`,`tick_val`) VALUES (NEW.dat, NEW.tim, NEW.price, NEW.val);
END

CREATE TRIGGER `trig` BEFORE INSERT ON `temp`
 FOR EACH ROW BEGIN
INS ERT IN TO ticks (`tick_date`,`tick_time`,`tick_price`,`tick_val`) VALUES (STR_TO_DATE(NEW.dat,'%d.%m.%Y'), NEW.tim, NEW.price, NEW.val);
END

CREATE TRIGGER `trig` BEFORE INSERT ON `temp`
 FOR EACH ROW BEGIN
INS ERT IN TO ticks (`tick_date`,`tick_time`,`tick_price`,`tick_val`) VALUES (DATE_FORMAT(NEW.dat,'%d.%m.%Y'), NEW.tim, NEW.price, NEW.val);
END

CREATE TRIGGER `trig` BEFORE INSERT ON `temp`
 FOR EACH ROW BEGIN
INS ERT IN TO ticks (`tick_date`,`tick_time`,`tick_price`,`tick_val`) VALUES (CONVERT(NEW.dat,DATE), NEW.tim, NEW.price, NEW.val);
END

  INS ERT  IN  TO `table` (`dat`) VALUES (STR_TO_DATE( '13.12.2017' ,'%d.%m.%Y'))  

  SEL ECT DATE_FORMAT(dat,'%d.%m.%Y') FR OM `table`  

INS ERT IN TO `table` (`dat`) VALUES (STR_TO_DATE('13.12.2017','%d.%m.%Y'))

SEL ECT DATE_FORMAT(dat,'%d.%m.%Y') FR OM `table`