I.CREATE_DATE BETWEEN TO_DATE('2007-04-02 00:00:00','YYYY-MM-DD hh24:mi:ss') AND TO_DATE('2007-04-03 23:59:59 ','YYYY-MM-DD hh24:mi:ss')
转载于:https://www.cnblogs.com/Sophia_Cool/archive/2008/10/24/1318848.html
转载于:https://www.cnblogs.com/Sophia_Cool/archive/2008/10/24/1318848.html