Bug #501 casting to date does not work properly

Description:
This bug is duplicate to #498 but I don't know how else to change the category
to "feature-request".

From the Debian Bug Tracking System. 
More information available at http://bugs.debian.org/190183. 
The bug was reported by Wichert Akkerman <wichert@wiggy.net>

MySQL does not implement casting to dates properly.

How to repeat:
mysql> select cast(now() as date);
+---------------------+
| cast(now() as date) |
+---------------------+
| 2003-04-22 16:51:15 |
+---------------------+
1 row in set (0.00 sec)

note that the time is not discarded as it should be. It should work
like this (example made using postgres):

template1=> select now(), cast(now() as date);
              now              |    now     
-------------------------------+------------
 2003-04-22 16:52:57.929235+02 | 2003-04-22
                                 ^^^^^^^^^^

Please see comments for #498 which is same issue.

This appears to be fixed, at least in 6.0.8.

mysql>  select cast(now() as date);
+---------------------+
| cast(now() as date) |
+---------------------+
| 2008-09-30          | 
+---------------------+
1 row in set (0.00 sec)

mysql> select version();
+--------------------------------+
| version()                      |
+--------------------------------+
| 6.0.8-alpha-valgrind-max-debug | 
+--------------------------------+
1 row in set (0.00 sec)