TO_DATE('2007-04-02 00:00:00','YYYY-MM-DD hh24:mi:ss')

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')
posted @ 2008-10-24 16:06  做你所想  阅读(633)  评论(0编辑  收藏  举报