select * from xcom.SENTMESSAGEBUFFERLOG where sysdate>sysdate-2;这样?????
select * from xcom.SENTMESSAGEBUFFERLOG where 日期字段XXXX>sysdate-2;
sentlogtime——这个应该是你的时间字段如果为data类型: select * from xcom.SENTMESSAGEBUFFERLOG where sentlogtime between sysdate-2 and sysdate不是data类型你就: to_date(sentlogtime,'yyyy-mm-dd hh24:mi:ss')
SELECT * FROM XCOM.SENTMESSAGEBUFFERLOG WHERE MESSAGEID >= 'yyyy-mm-dd' AND MESSAGEID <= 'yyyy-mm-dd' 这样可以不
SELECT * FROM XCOM.SENTMESSAGEBUFFERLOG WHERE SENTLOGTIME > current_date()-2 ;
select * from xcom.SENTMESSAGEBUFFERLOG where sentlogtime between sysdate-2 and sysdate不是data类型你就:
to_date(sentlogtime,'yyyy-mm-dd hh24:mi:ss')