因為我常常會忘記加時分秒啦，
而且本來我很單純的覺得他就是會抓那整個區間的資料，
只是一個有轉to_char，一個沒有，
結果出來可以差50筆。
**這是錯的，可是我明明覺得他看起來一樣
SELECT COUNT(CUT_NO) CUT_NO
FROM rol.rol001m
WHERE R_INSP_DATE BETWEEN TO_DATE('2007/01/21','YYYY/MM/DD')
FROM rol.rol001m
WHERE R_INSP_DATE BETWEEN TO_DATE('2007/01/21','YYYY/MM/DD')
AND TO_DATE('2007/01/27','YYYY/MM/DD')
AND PATROL_INSP IS NOT NULL
SELECT COUNT(CUT_NO) CUT_NO
FROM rol.rol001m
WHERE TO_CHAR(R_INSP_DATE,'YYYY/MM/DD') BETWEEN '2007/01/21' AND '2007/01/27'
AND PATROL_INSP IS NOT NULL
AND PATROL_INSP IS NOT NULL
SELECT COUNT(CUT_NO) CUT_NO
FROM rol.rol001m
WHERE TO_CHAR(R_INSP_DATE,'YYYY/MM/DD') BETWEEN '2007/01/21' AND '2007/01/27'
AND PATROL_INSP IS NOT NULL
------
**這才是對的
SELECT COUNT(CUT_NO) CUT_NO
FROM rol.rol001m
WHERE R_INSP_DATE BETWEEN TO_DATE('2007/01/21 00:00:00','YYYY/MM/DD HH24:Mi:ss')
FROM rol.rol001m
WHERE R_INSP_DATE BETWEEN TO_DATE('2007/01/21 00:00:00','YYYY/MM/DD HH24:Mi:ss')
AND TO_DATE('2007/01/27 23:59:59','YYYY/MM/DD HH24:Mi:ss')
AND PATROL_INSP IS NOT NULL
SELECT COUNT(CUT_NO) CUT_NO
FROM rol.rol001m
WHERE TO_CHAR(R_INSP_DATE,'YYYY/MM/DD') BETWEEN '2007/01/21' AND '2007/01/27'
AND PATROL_INSP IS NOT NULL
AND PATROL_INSP IS NOT NULL
SELECT COUNT(CUT_NO) CUT_NO
FROM rol.rol001m
WHERE TO_CHAR(R_INSP_DATE,'YYYY/MM/DD') BETWEEN '2007/01/21' AND '2007/01/27'
AND PATROL_INSP IS NOT NULL
------
此時此刻，我心裡真的覺得很雪特 -___-
請先 登入 以發表留言。