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 @OLD_SQL_MODE=@@SQL_MODE*/;
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
