27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT CONVERT(DateTime,matchDate,120)
select * from SoccerEvent where 1=1
and datediff(dd,matchDate,'2009-6-3')=0
and datepart(hh,matchDate) = 2
select * from SoccerEvent where 1=1 and datediff(dd,matchDate,'2009-6-2')=0
select * from SoccerEvent where 1=1
and datediff(mm,matchDate,'2009-6-2')=0