Compare table datetime, SQL & SSIS

I am trying to add a step in my SSIS job where it checks a table (FYI, so this table has only 1column which is a datetime data type that gets updated daily with a datetime from another table) whether it is greater than midnight or not. how do I setup this with the appropriate query. This is the table name - ETLTimeCheck This is the only column in this table- EXEC_END_TIME I started out with this idea:

SELECT...
FROM [dbo].[ETLTimeCheck] 
WHERE [EXEC_END_TIME] > DATEADD(D,0,DATEDIFF(D,0,GETDATE()))

This is suppose to return a midnight-> DATEADD(D,0,DATEDIFF(D,0,GETDATE())) I know there must be an 'IF' statement inside my query. Can you please help me finish this?