better query for select results based on date.

Jonathan Brotto 420

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

Olaf Helper 47,586 Reputation points

2024-09-30T19:56:06.1133333+00:00

Your post is very unclear, we don't have your database to test anything, and you didn't post table design + sample data + expected result; no one can even guess nor can give a suggestion.

You have to provide much more details.

Answer accepted by question author

Erland Sommarskog 128.9K Reputation points MVP Volunteer Moderator

2024-09-30T21:18:01.41+00:00
WHERE insertTimestamp >= @date AND InsertTimestamp < dateadd(DAY, 1, @date)
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer