Manejar timestamp

[huesos52]

Si se puede con la función DATE o la función TIME.

Código MySQL:

mysql> SELECT DATE(now());
+-------------+
| DATE(now()) |
+-------------+
| 2010-09-06  |
+-------------+
1 row in set (0.01 sec)
 
mysql> SELECT TIME(now());
+-------------+
| TIME(now()) |
+-------------+
| 13:08:19    |
+-------------+
1 row in set (0.00 sec)
 
mysql> SELECT now();
+---------------------+
| now()               |
+---------------------+
| 2010-09-06 13:08:28 |
+---------------------+
1 row in set (0.00 sec)
 

saludos