create procedure sp_cube_inverter_d (in p_nowdate datetime)
begin
  declare v_nowdate    char(8);
  declare v_curdate    datetime;

  set v_curdate = left(p_nowdate,10);
  set v_nowdate = replace(cast(v_curdate as char(10)),'-','');

mysql> delimiter //
mysql> create procedure sp_cube_inverter_d (in p_nowdate datetime)
    -> begin
    ->   declare v_nowdate    char(8);
    ->   declare v_curdate    datetime;
    ->
    ->   set v_curdate = left(p_nowdate,10);
    ->   set v_nowdate = replace(cast(v_curdate as char(10)),'-','');
    -> end //
Query OK, 0 rows affected (0.26 sec)

mysql> delimiter ;
mysql>

------解决方案--------------------
探讨


( in p_nowdate datetime )
加个空格就好了，晕。

mysql语法太敏感了