KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to build a query that will select based on a DateTime column SyncDate . As some background, the table I query from gets imports daily in the thousands at the exact same time everyday. I want to find the entries that did not import at the "regular" time of day. Therefore, I want to query where the time in the DateTime column is between two times: lets say 14:00-14:30 (2-230) on ANY day/month/year period. SELECT * FROM MyTable WHERE DatePart(SyncDate, ..?) BETWEEN (14:00..?) and (14:30..?) The DatePart function seems to be what I need, but I don't understand how to apply it to this situation. Your help is much appreciated oh great queriers. EDIT: I was mistaken, I am running SQL-Server-2005 as my backend. Sorry!
Tags (comma-separated)
Save Edits
Cancel