select to_char(sysdate,'YYYYMMDD hh:mm:ss') from dual
select concat(to_char(sysdate,'YYYYMMDD'),' 12:00:00') from dual
不行啊,我使用 v_adp.sys_time := TO_CHAR(v_adp.sys_time,'yyyymmdd') || ' 12:00:00'; 显示PLS-00307: too many declarations of 'TO_CHAR' match this call 其中v_adp是一个游标,sys_time是时间变量
v_adp.sys_time := TO_CHAR(v_adp.sys_time,'yyyymmdd') || ' 12:00:00';
显示PLS-00307: too many declarations of 'TO_CHAR' match this call
其中v_adp是一个游标,sys_time是时间变量