sql语句出现问题(在线等!)
sql="select msg,to_char( to_date(recv_time, 'YYYYMMDDHH24MISS'), 'MM-DD HH24:MI') as addtime,DST_PHONENUM,SRC_PHONENUM from recv_stat";
sql=sql+" where (DST_PHONENUM='8118') or (DST_PHONENUM='095688') AND ((to_date(recv_time,'YYYYMMDD'))==(to_date(getnowtime(), 'YYYYMMDD')))";
sql=sql+" order by recv_time desc";
错误提示
Search error: ORA-00920: invalid relational operator error1