如何从datetime作为数据类型（TSQL）的列获取当前日期部分的条目

I have daily scheduled task that queries a table which includes column named AttemptDate with datetime as datatype. However the task queries all entries regardless of the date. So when the tasks executes, it outputs entries of all the dates as shown below:I have daily scheduled task that queries a tabl