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