how to search date in sql query
snippet in sql

how to search date in sql query

user4718

 select * from test 
 where date between '03/19/2014' and '03/19/2014 23:59:59'

how to search date in sql query

user2744

 select * from test 
 where datediff(day, date, '03/19/2014') = 0