title: Selecting all the data using time greater than 4pm
body: <p>I need to select the Data containing time > 4pm in <code>datatimestamp</code> every day in SQL Server Management Studio Microsoft SQL Server 2005 - 9.00.4060.00 (X64)   DB table which has two years of data. What's the best way to do this? My time stamp has following format:<code>DATETIME, '2005-10-13 16:00:00', 102</code>.  I have data at random times every afternoon. I need to get the data after 4pm for every day. Not just for one day. </p>
  
  <p>For example i tried for one day like this:</p>
  
  <pre><code>SELECT     Yield, Date, ProductType, Direct
  FROM         MIAC_CCYX
  WHERE     (Date &lt; CONVERT(DATETIME, '2005-10-13 16:00:00', 102))  Thanks for help
  </code></pre>