title: Omitting the Milliseconds in a Date
body: <p>When I select from SQL Server, I want to get a date, but omit the millisecond value, and I want it to be as a date type.  So if I have a value <code>1/1/2009 1:23:11.923</code>, I want to omit the millisecond but retain the date type, so that it will be the value <code>1/1/2009 1:23:11.000</code> (I know you really can't omit the millisecond value with a date, just want it to be zero).</p>
  
  <p>Is there a function in SQL Server to do this?  Or do I have to write my own function?  Again, I don't want it as a <code>varchar</code> type, but a <code>datetime</code> type.</p>