SQL Server中时间段查询

/****** Script for SelectTopNRows command from SSMS  ******/

 


select * from dbo.VehicleData20100901 where  CreateDate between '2010-09-01 07:00:0' and '2010-09-01 09:00:0' 



select * from FCDBackup20100900_new.dbo.VehicleData20100901 where DATEDIFF (S, '2010-09-01 07:00:0', CreateDate )  > 0 and DATEDIFF(S, '2010-09-01 09:00:0', CreateDate )<0