mysql> select current_timestamp();

+---------------------+

| current_timestamp() |

+---------------------+

| 2010-01-18 21:24:37 |

+---------------------+

1 row in set (0.00 sec)

mysql> select current_date();

+----------------+

| current_date() |

+----------------+

| 2010-01-18 |

+----------------+

1 row in set (0.00 sec)

mysql> select current_time();

+----------------+

| current_time() |

+----------------+

| 21:24:46 |

+----------------+

1 row in set (0.00 sec)