CODE EXAMPLE FOR SQL

sql server select where date

select * from test where cast ([date] as date) = '03/19/2014';