Question

mysql存储过程中怎么用date

Answer 1

MySQL教程4 MySQL8运算符、函数、存储过程及新增数据类型 17.之创建带有IN和OUT参数的存储过程 学习猿地

Answer 2

mysql存储过程中怎么用date
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 <a href="https://www.baidu.com/s?wd=DUAL&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y4mhuBuH01PADduyn1PAfk0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3En1m4PW61PjnznH6YPjc3nW0Y" target="_blank" class="baidu-highlight">DUAL</a>;
<a href="https://www.baidu.com/s?wd=END&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y4mhuBuH01PADduyn1PAfk0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3En1m4PW61PjnznH6YPjc3nW0Y" target="_blank" class="baidu-highlight">END</a>$$

DELIMITER ;