oracle date 查询
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提示错误是文字与格式字符串不匹配,
--------------------编程问答--------------------
select B.OPERATORID,U.USR_Name,sum(FileScanNumber)看一下字符转成时间,应该是这里的问题,不太懂ORACLE --------------------编程问答-------------------- 你的SUBMIT_DATE是字符串类型的,真不知道那表谁建的.
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
我看你还是自己手工用to_date函数转换下SUBMIT_DATE的值吧,转换前看下SUBMIT_DATE的存放格式.
补充:.NET技术 , C#