Question

mysql存储过程中怎么用date

Answer 1

跟字符串一样的处理，当然还有一些 特殊的 时间处理函数DELIMITER $$DROP PROCEDURE IF EXISTS `datatime`$$CREATE /*[DEFINER = { user | CURRENT_USER }]*/ PROCEDURE `iccsdb`.`datatime`() /*LANGUAGE SQL | [NOT] DETERMINISTIC | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } | COMMENT 'string'*/ BEGIN DECLARE dattime DATETIME DEFAULT '2013-10-10'; SELECT dattime FROM DUAL; END$$ DELIMITER ;