datetime转换成date

Question

MYSQL 怎么将datetime转换成date ???

Answer 1

mysql> select convert(now(),date);
+---------------------+
| convert(now(),date) |
+---------------------+
| 2007-09-29          |
+---------------------+
1 row in set (0.13 sec)

Answer 2

select   convert(char(10), "2007-07-24   21:20:08.000 ",120) 
                      
----------   
2007-07-24 

Answer 3

datetime转换失败是什么原因啊？谢谢！！！！