CODE EXAMPLE FOR SQL

how to search date in sql query

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