query question about dates
Posted on 2016-07-21
I have a bunch or transactions that are stamped with a date time.
i want to select all the transactions that happened on a certain date. it seems like when i do this though, that the minutes and seconds
of the date stamp are throwing off my select variable and returning no values.
column addeddate has value of '2016-07-21 08:55:55:888'
and i query to return all rows that have an addeddate of '2016-07-21'
i get no hits on my results
whats an efficient way to get through this besides using greater than and less than or between.