我希望查询一段时间内的数据
select Oper_name,Oper_time,Oper_thing from User_Log where Oper_time >= '2007-2-5 17:12:46' and Oper_time <= '2008-3-23 17:12:46' //法完成预期操作
应该如何处理了,谢谢了
select Oper_name,Oper_time,Oper_thing from User_Log where Oper_time >= '2007-2-5 17:12:46' and Oper_time <= '2008-3-23 17:12:46' //法完成预期操作
应该如何处理了,谢谢了
有效性验证:自己验证,datetime系统验证
比较:还得转换为时间来比较,除非严格按照这种格式:yyyy-mm-dd hh:mm:ss
否则要先转换为datetime型.select Oper_name,Oper_time,Oper_thing from User_Log where cast(Oper_time as datetime) >= '2007-02-05 17:12:46' and Oper_time <= '2008-03-23 17:12:46'