cast(fromTime as datetime) cast(endTime as datetime) 我不建议字符串比较,因为字符的顺序是根据所存的数据表的位置决定,不是很好确定.
create view v_Temp as SELECT Convert(VARCHAR(10),OrderEndTime,120) AS OrderEndTime,SUM(TotalMoney)AS TotalMoney,SUM(ReceiveMoney)AS TotalReceiveMoney,CheckOutType FROM OrderInfoLast group by Convert(VARCHAR(10),OrderEndTime,120),CheckOutType goselect datediff(ms,OrderEndTime,@fromTime) as fromTime,datediff(ms,OrderEndTime,@endTime) as endTime from v_Temp 判断结果是>0还是<0就可以了
cast(endTime as datetime)
我不建议字符串比较,因为字符的顺序是根据所存的数据表的位置决定,不是很好确定.
as
SELECT Convert(VARCHAR(10),OrderEndTime,120) AS OrderEndTime,SUM(TotalMoney)AS TotalMoney,SUM(ReceiveMoney)AS TotalReceiveMoney,CheckOutType
FROM OrderInfoLast
group by Convert(VARCHAR(10),OrderEndTime,120),CheckOutType
goselect datediff(ms,OrderEndTime,@fromTime) as fromTime,datediff(ms,OrderEndTime,@endTime) as endTime from v_Temp
判断结果是>0还是<0就可以了