DECLARE @dt datetime, @hhmm char(5), @t_min char(5), @t_max char(5) SET @dt = GETDATE() SET @hhmm = CONVERT ( char(5), @dt, 8) SET @t_min = '11:00' SET @t_max = '13:15' PRINT @dt PRINT @hhmm IF @hhmm >= @t_min AND @hhmm <= @t_max PRINT 'Time is between ' + @t_min + ' and ' + @t_max ELSE PRINT 'Time is out of range' * SQL Select statement SELECT * FROM mytable ; WHERE CONVERT ( char(5), mydatefield, 8) BETWEEN @t_min AND @t_max