ASP跟oracel谁对谁错

[lovehwq21]

我有一个表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'))

急救！！！

[qdubit]

关注！

[lovehwq21]

up

[lovehwq21]

啊？我突然多了座小山了！！！
高兴！

[lovehwq21]

竟然没人答？？