select * from MobleUserOrderHistory
where convert(char(8),Moble_Last_Modfy_Time,108)>'00:00:00'
and convert(char(8),Moble_Last_Modfy_Time,108)<='05:00:00'
where convert(char(8),Moble_Last_Modfy_Time,108)>'00:00:00'
and convert(char(8),Moble_Last_Modfy_Time,108)<='05:00:00'
这局话不对啊!提示是语法错误!
where datepart(ss,Moble_Last_Modfy_Time)>0
and datepart(ss,Moble_Last_Modfy_Time)<=5
where datepart(hour,Moble_Last_Modfy_Time)=0
and datepart(minute,Moble_Last_Modfy_Time) between 0 and 5