change date format using SQL - urgent

[therry]

Hi,

I'm having a field which data type is datetime (ex. 2002-07-18 10:06:58.373 format). If I want to do a SELECT statement to display this field as 2002-07-18 format only without the time, how can I do that using SQL statement?

Thanks

[Spookster]

http://www.mysql.com/doc/en/DATETIME.html