ASP跟oracel谁对谁错
我有一个表T_FIX,有好几个字段,其中有DEFECT_STYLE(varchar)、LAST_DATE(varchar)、DEFFECT_AMOUNT(varchar)、writeman(varchar),
为什么下面的语句在ASP执行的时候没报错!数据记录总数为0
select * from T_FIX where
(DEFECT_STYLE='年') and
(ADD_MONTHS(LAST_DATE,to_number(DEFFECT_AMOUNT)*12)=to_date('2003-3-2','YYYY-MM-DD')) and (writeman = '黄子三')
而且,同样的功能,不过变换一个顺序,SQL就执行不了啦
select * from T_FIX where
(DEFECT_STYLE='年') and (writeman = '黄子三')
and (ADD_MONTHS(LAST_DATE,to_number(DEFFECT_AMOUNT)*12)=to_date('2003-3-2','YYYY-MM-DD'))
急救!!!