How to Convert following date to YYYY-MM-DD

I entered data into a database, but the date is off, it 开发者_运维百科is showing to the seconds.

How can i do a select statement to get this:

2010-02-18 07:45:00

To This:

2010-02-18

I am not the computer guy here....Thanks!

---

SELECT Convert(varchar(10), DateColumn, 120) FROM TABLE

---

For any SQL Server version

select dateadd(d, datediff(d, 0, datecolumn), 0), ..
from ..

or for your 2008

select CAST(datecolumn as Date), ....
from ..

---

DATE('2010-02-18 07:45:00');  

or variable in there

Or just change the column type definition from datetime to date