一个查询的问题！！！！！！！！

Question

"SELECT PeripheralNumber,FirstName,DateTime,TalkTime,RingTime FROM t_Agent,t_Termination_Call_Detail WHERE t_Agent.SkillTargetID = t_Termination_Call_Detail.AgentSkillTargetID AND t_Agent.PeripheralNumber = "+WorkID+" AND DateTime>=CONVERT(DATETIME,'" + beginTime + "') AND  DateTime<=CONVERT(DATETIME,'" + endTime + "') ORDER BY PeripheralNumber ASC"

Answer 1

看你理解了：
between '2003-4-17' and '2003-4-18' =======  >='2003-4-17' and <='2003-4-18'
"SELECT PeripheralNumber,FirstName,DateTime,TalkTime,RingTime FROM t_Agent,t_Termination_Call_Detail WHERE t_Agent.SkillTargetID = t_Termination_Call_Detail.AgentSkillTargetID AND t_Agent.PeripheralNumber = " + WorkID + " AND [DateTime]>=CONVERT(DATETIME,'" + beginTime + "') AND [DateTime]<dateadd(day,1,CONVERT(DATETIME,'" + endTime + "')) ORDER BY PeripheralNumber ASC

Answer 2

或者你 convert (varchar(10),datetime,120) between '2003-05-17' and '2003-05-18'