SELECT count(*)
FROM MSG_SEND
WHERE STATUS = '1'
AND SEND_ID = '210000000004843'
AND CONTENT like '%_%'
AND SEND_TIME >= to_date('2013-08-02 00:00:00','YYYY-MM-DD HH24:Mi:SS')
AND SEND_TIME <= to_date('2013-08-22 23:59:59','YYYY-MM-DD HH24:Mi:SS')
escape '\'
执行上面语句的时候会报“命令未正确结束“这种错误
而下面的语句可以正常执行
SELECT count(*)
FROM MSG_SEND
WHERE STATUS = '1'
AND SEND_ID = '210000000004843'
AND SEND_TIME >= to_date('2013-08-02 00:00:00','YYYY-MM-DD HH24:Mi:SS')
AND SEND_TIME <= to_date('2013-08-22 23:59:59','YYYY-MM-DD HH24:Mi:SS')