title: how to ignore Minutes and date and time field and only take yyy/mm/dd/hh and count the records that shares the same date and time (hour only)
body: <p>in the following table I'm trying to compare it to itself by using self join to be able to count TestOrderItemID that share the same createdate excluding minutes and seconds </p>
  
  <p><img src="https://i.stack.imgur.com/PY6lK.png" alt="enter image description here"></p>
  
  <p>for example it should count the createdate that shares the same Year/Month/Day/Hour while ignoring the minutes and seconds, the outcome should be like </p>
  
  <p><img src="https://i.stack.imgur.com/6ShVG.png" alt="enter image description here"></p>
  
  <p>for the first two record with TestOrderItemID 1 and 2 the count_Oftest_sameDate should equal 2 since we will ignore the seconds and minutes ,
  also for the last 3 records 16 and 17 and 5 the count_Oftest_sameDate equals 3 since it ignored the minutes and only took hour into consideration </p>