SQL Query question:
WHERE InsertTime IN (2011-11-12-22:33)
This will show in the database every row in the column InsertTime that have text: 2011-11-12-22:33
Now the data come in around date 2011 november 20 clock time 22:33, clock time is hard coded in the application, I can't do anything there, It would be nice if it only shows date, that however is not the case, is it possible to query 2011-11-12? I tried to put: WHERE InsertTime IN (2011-11-12) It didnt work tho.