Funcion explode

[huesos52]

Con date_format visona.

Código MySQL:

mysql> SELECT *FROM fechita;
+---------------------+
| fec                 |
+---------------------+
| 2010-08-10 08:24:46 |
+---------------------+
1 row in set (0.00 sec)
 
mysql> SELECT 
>DATE_FORMAT(fec,'%d-%m-%Y') fecha, 
>DATE_FORMAT(fec,'%h:%i:%s')hora 
>FROM fechita;
+------------+----------+
| fecha      | hora     |
+------------+----------+
| 10-08-2010 | 08:24:46 |
+------------+----------+
1 row in set (0.02 sec)