Date Question ...

Date Question ...

 

  

Hi All,

Kind of a stupid question. How can I get the date from datetime? I had done
this before but some how couldn't think today, I think I am ready for the
week end.. :)

For example :
This is what I have : 2003-05-29 11:49:28.680
and I need : 2003-05-29
MS Sql Server LazyDBA home page