title: How can I compare only hour and minute in sql
body: <p>I have a column stop_execution_date in sysjobactivity table. I need to get details of job only which ran after 4:10 AM.</p>
  
  <p>I tried it using </p>
  
  <pre><code>    cast(DATEPART(hour, sja.stop_execution_date) as varchar)+cast(DATEPART(minute, sja.stop_execution_date) as varchar) &gt;410
  </code></pre>
  
  <p>But, if job completes at 9:05 AM it is not accepting because datepart(hour) is 9 and datepart(minute) is 5. By using + we are getting 95 instead of 905, which is less then 410.</p>
  
  <p>Can you please suggest me a good way to do that.</p>