SQL数据库的存储过程中使用到系统函数datepart:
v_month_dayofweek = datepart(weekday,cast((year+month+daySty) as datetime)); year/month为传入的参数 varchar2类型;daySty为自定义的变量 varchar(2)类型,取值是:
if(day<10) then
daySty := '0'+cast(day as varchar2);
else
daySty := cast(day as varchar2); 现望把 v_month_dayofweek = datepart(weekday,cast((year+month+daySty) as datetime)); 转化为oracle数据库中方法????请教????
v_month_dayofweek = datepart(weekday,cast((year+month+daySty) as datetime)); year/month为传入的参数 varchar2类型;daySty为自定义的变量 varchar(2)类型,取值是:
if(day<10) then
daySty := '0'+cast(day as varchar2);
else
daySty := cast(day as varchar2); 现望把 v_month_dayofweek = datepart(weekday,cast((year+month+daySty) as datetime)); 转化为oracle数据库中方法????请教????
v_month_dayofweek := to_char(to_date(year||month||daySty,'yyyymmdd'),'d');
谢谢,没错;
还有个问题:
SqlStr := substr(SqlStr,1,len(SqlStr)-1)+'where pk_psndoc'''+......
中的 len函数如何修改为oracle的呢?谢谢!!