title: Should we explicitly convert datetime to date or let SQL Server handle it
body: <p>I'm using SQL Server 2008. I have declared a variable as Date. My table has a Datetime column which I'm fetching. When I assign the datetime to date variable, I only get a Date. Everything works good. But are there any performance implications of assigning DateTime to a Date variable without Convert/Cast and letting SQL Server handle it? Or is it advisable to Convert/Cast before we assign?</p>