Determining what this Delete Statement does

Question

Not really a sql programmer. It looks to me that its looking for anything where exch_date is today and deleting it. Is that correct?

DELETE FROM dbo.Table where 
DATEADD(dd, DATEDIFF(dd,0,exch_Date),0) = DATEADD(dd, DATEDIFF(dd,0,GETDATE()),0)

Answer 1

One way to validate this is to input it into a select statement. This will help you identify all the rows that will be affected.

Select * from db.table
where DATEADD(dd, DATEDIFF(dd,0,exch_Date), 0)
    = DATEADD(dd, DATEDIFF(dd,0,GETDATE()), 0)

Answer 2

It appears to be doing a whole day (as in no time component) comparison between exch_Date and the current date.