select * from urTable 
Where urDateColumn 
Between '2007-10-20 17:00:00 PM' 
    and '2007-10-21 09:00:00 AM'

Declare @hour varchar(100) 
 set @time=convert(varchar,getdate(),114)
 set @hour=SUBSTRING(@time,1,2) 
if(convert(int,@hour)>8 and convert(int,@hour)<19)
begin
print @time
print @hour
end

CREATE PROCEDURE usp_StartStop_services

AS
Begin
Declare @date as  varchar(100)
SET @date = convert(varchar, getdate(), 114)
Print @date

if @date >= '19:00:00.000' 
	exec MASTER.DBO.xp_cmdshell 'NET Stop SQLSERVER'
Else if

   @date >= '09:00:00.00' and @date < '19:00:00.000' 

	exec MASTER.DBO.xp_cmdshell 'NET  START SQLSERVER'
END
GO

Declare @hour varchar(100) 
 set @time=convert(varchar,getdate(),114)
 set @hour=SUBSTRING(@time,1,2) 
if(convert(int,@hour)>8 and convert(int,@hour)<19)
begin
print @time
print @hour
end