M_NAME PROCESS_NAME PRO_SERIAL STARTDATE ENDDATE ELAPSED_TIME
F/T_L3_F/T24 F/T W0A310HQ 2010-3-1 2010-3-2 8:51:49 118309
F/T_L3_F/T25 F/T W0A2QGHM 2010-3-1 16:34:45 2010-3-1 17:15:37 2452
F/T_L3_F/T25 F/T W0A2QGUG 2010-3-1 21:16:14 2010-3-1 21:56:55 2441
F/T_L3_F/T25 F/T W0A2SCY3 2010-3-1 22:30:19 2010-3-1 22:50:37 1218SELECT * FROM TEST T
WHERE T.STARTDATE >= TO_DATE('2010-1-1 00:00:00','YYYY-MM-DD HH24:MI:SS')
AND T.ENDDATE < SYSDATE请问以上表,怎么样去掉STARTDATE=2010-3-1这行数据
谢谢
F/T_L3_F/T24 F/T W0A310HQ 2010-3-1 2010-3-2 8:51:49 118309
F/T_L3_F/T25 F/T W0A2QGHM 2010-3-1 16:34:45 2010-3-1 17:15:37 2452
F/T_L3_F/T25 F/T W0A2QGUG 2010-3-1 21:16:14 2010-3-1 21:56:55 2441
F/T_L3_F/T25 F/T W0A2SCY3 2010-3-1 22:30:19 2010-3-1 22:50:37 1218SELECT * FROM TEST T
WHERE T.STARTDATE >= TO_DATE('2010-1-1 00:00:00','YYYY-MM-DD HH24:MI:SS')
AND T.ENDDATE < SYSDATE请问以上表,怎么样去掉STARTDATE=2010-3-1这行数据
谢谢
WHERE T.STARTDATE >= TO_DATE('2010-1-1 00:00:01','YYYY-MM-DD HH24:MI:SS')
AND T.ENDDATE < SYSDATE改成01秒就可以了
SELECT * FROM TEST T
WHERE T.STARTDATE >= TO_DATE('2010-3-1 00:00:01','YYYY-MM-DD HH24:MI:SS')
AND T.ENDDATE < SYSDATE
SELECT *
FROM TEST T
WHERE T.STARTDATE >= TO_DATE('2010-1-1 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND
T.ENDDATE < SYSDATE AND
T.STARTDATE <> DATE '2010-03-01'
谢谢
FROM TEST T
WHERE T.STARTDATE >= TO_DATE('2010-1-1 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
AND T.ENDDATE < SYSDATE
AND to_char(T.STARTDATE,'HH24:MI:SS') <> '00:00:00' --过滤没有小时,分,秒的
length(STARTDATE)<= 10