I am trying to do a query by datetime
basically says, select all data by this day.
the problem I am having is that if I put in a day like 2010-03-05
it pulls an empty value because there is a timestamp.
all I want to do is pull data by that entire day.
input is appreciated
query is below
Select * FROM IncidentReport INNER JOIN
HowCertain ON IncidentReport.HowCertainID = HowCertain.HowCertainID INNER JOIN
Locations ON IncidentReport.LocationsID = Locations.LocationsID INNER JOIN
Perpetrators ON IncidentReport.PerpetratorsID = Perpetrators.PerpetratorsID INNER JOIN
Tactics ON IncidentReport.TacticsID = Tactics.TacticsID
WHERE (IncidentReport.TimeOccured LIKE @TimeOccured)
ORDER BY IncidentReport.TimeOccured DESC