Trigger 2007-10-11 - By Patricio A. Bruna
Back
Hi,
I have a problem with a trigger which should conver a unix timestamp to a MySQL
date datatype.
The trigger works if the column is varchar, but when the column is date type,
it write the date of 1969-31-12.
Any ideas?
DROP TABLE IF EXISTS `visitas`;
CREATE TABLE `visitas` (
`id` int(11) NOT NULL auto_increment,
`date` varchar(25) default NULL,
`elapsed` int default NULL,
`src_ip` varchar(15) default NULL,
`result_code` varchar(25) default NULL,
`http_status` TINYINT default NULL,
`bytes` int default NULL,
`request` varchar(50) default NULL,
`authname` varchar(10) default NULL,
`type` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!50003 SET @(protected)=@@(protected)*/;
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="STRICT_TRANS_TABLES" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`root`@`localhost` */ /*!50003 TRIGGER
`unix2normaltime` BEFORE INSERT ON `visitas` FOR EACH ROW begin
set New.date=date(from_unixtime(New.date));
end */;;
When
|
|
