Mysql query to get current date from database

Mysql query to get current date from database

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

now function provide date with time, curdate output is only date

Questions List - Database