CODE EXAMPLE FOR SQL

how to search date in sql query

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