How can I compare only hour and minute in sql
How about:
(DATEPART(hour, sja.stop_execution_date) = 4 and (DATEPART(minute, sja.stop_execution_date) > 10)
OR DATEPART(hour, sja.stop_execution_date) > 4
Could cast as a time.
cast(sja.stop_execution_date as time) > '04:10:00.0000000'