在任务中心里执行CALL "GGDBUSER"."WYDETAIL"(substr(char(current date -1 day),7,4)||substr(char(current date -1 day),1,2)||substr(char(current date -1 day),4,2)) 时间参数格式类似为20111013,而想把时间参数修改为2011-10-12,把时间参数写成substr(char(current date -1 day),7,4)||'-'|substr(char(current date -1 day),1,2)||'-'|substr(char(current date -1 day),4,2)) 得到的时间格式却为12/11/2011 请牛人解决 不胜感激!
------解决方案--------------------------------------------------------
http://doc.chinaunix.net/db2/200904/164393.shtml