Mysql query to get current date from database?

mysql, sql

Solution

The fine manual has this to say about the `NOW` function:

mysql> SELECT NOW();
        -> '2007-12-15 23:50:26'

If you want just the date, then use `CURDATE`. The fine manual has this to say about the `CURDATE` function:

mysql> SELECT CURDATE();
        -> '2008-06-13'

Problem

Can anyone please suggest the query to get current date from data base ?

Original source