better query for select results based on date.

Question

What is the best way to write this code to get the date results? I have the time throughout the day in the datetime field.

SELECT * FROM Reconciliation.Documents D
Inner Join Reconciliation.DocumentsTransaction T
ON D.DocumentPKey = T.DocumentPKey
WHERE 
PartnerID = 'Busdepot' AND EDIDirection = 'inbound' 
and EDITransactionType = '850' 
and year(InsertTimestamp) = year('2024-09-18')
and month(InsertTimestamp) = month('2024-09-18')
and day(InsertTimestamp) = day('2024-09-18')
ORDER BY d.DocumentPKey

Answer 1

WHERE insertTimestamp >= @date
  AND InsertTimestamp < dateadd(DAY, 1,  @date)