none
Oracle date 查询 RRS feed

  • 问题

  • select B.OPERATORID,U.USR_Name,sum(FileScanNumber) from Key_Batch B, Key_Users U  where B.OperatorID=U.USR_ID and (SUBMIT_DATE Between  to_date('2009-08-07 00:00:00','yyyy-MM-dd HH24:MI:SS') and  to_date('2009-08-07 23:59:59','yyyy-MM-dd HH24:MI:SS')) group by OPERATORID, USR_Name,USR_ID


    提示错误是文字与格式字符串不匹配,
    2009年8月7日 12:36

答案

  • 关于PL/SQL的问题,请去forums.oracle.com这样的oracle论坛提问。

    Please mark the post answered your question as the answer, and mark other helpful posts as helpful.
    Visual C++ MVP
    2009年8月7日 13:33
    版主