SQL数据库系统函数 datepart 转化 oracle数据中的使用????
Josir 2009-03-11 08:22:24 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数据库中方法????请教????