how to provide date in sql query code example

Example: how to search date in sql query

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