 <p>This might hepls you</p> <pre><code>declare @t table(a date,b time) insert into @t values (getdate(),'7:00:00 AM') select * from @t where a&gt;'2015/01/19' or (a=getdate() and a&gt;'6:00:00 AM') </code></pre>